DB2 Interview Questions
Questions Answers Views Company eMail

what is the process of precompiler?

2 9222

What is buffrpool? Where we use it ?

Tesco,

2 8203

what is Runstats? Whem will u choose to runatats?

Danske,

1 7217




what is REORG? what is the use?

4 8020

What is the difference between a package and a plan?

Mphasis, L&T, Infosys,

6 34511

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 3625

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

1 5329

What is a clustered index?

1 8638




When will you chose to run RUNSTATS?

1 5749

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

3 4403

What is meant by a unit of recovery?

1 3082

What is CHECK PENDING ?

4 10517

What is a thread?

3 3671

What is filter factor?

2 7088

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

1 5739


Post New DB2 Questions






Un-Answered Questions { DB2 }

Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

4785


what is diffrence b/w file-aid tool and file-aid utility???

2871


While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

602


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 .....

1121


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

7004






How do we specify index to include or not during bind process.

953


what is db2 restart?

905


have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

439


When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

2266


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

1422


I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

1030


Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

1924


I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

890


what is the responsibility of the construction superintendent

879


is it compulsory commitment control in journal?

1207