DB2 Interview Questions
Questions Answers Views Company eMail

what is the process of precompiler?

2 10333

What is buffrpool? Where we use it ?

Tesco,

2 9021

what is Runstats? Whem will u choose to runatats?

Danske,

1 8284




what is REORG? what is the use?

4 8969

What is the difference between a package and a plan?

Mphasis, L&T, Infosys,

6 36664

How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?

2 4166

How do you filter out the rows retrieved from a Db2 table ?

1 6000

What is a clustered index?

1 9244




When will you chose to run RUNSTATS?

1 6212

What does DML stand for and what are some examples of it?

IBM,

3 5102

What is meant by a unit of recovery?

1 3480

What is CHECK PENDING ?

4 11406

What is a thread?

3 4128

What is filter factor?

2 7546

What's the maximum number of volumes that can be added to a STOGROUP?

IBM,

1 6188


Post New DB2 Questions






Un-Answered Questions { DB2 }

What is the syntax for FETCH in DB2 ?

7


Which command is used to connect to a database in DB2 ? Give the Syntax.

5


Mention the location where the output received from explain statement is stored.

2


SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

7469


What is the difference between dbm cfg and db cfg file in db2 ?

11






in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

1039


How to resolve deadlock issue

10933


Define sqlca.

5


Is it possible to create an Instance in DB2 using DB2 Control Center ?

12


can we view the access paths created by dbrm ? how ? thx

4795


Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

1262


Explain the function of data manager.

6


File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

1556


Explain about cursor stability?

4


What r the comman abends in db2, jcl and cobol???????

1192