DB2 Interview Questions
Questions Answers Views Company eMail

what is the process of precompiler?

2 6312

What is buffrpool? Where we use it ?

Tesco,

2 5976

what is Runstats? Whem will u choose to runatats?

Danske,

1 4556




what is REORG? what is the use?

4 5885

What is the difference between a package and a plan?

Mphasis, L&T, Infosys,

6 28392

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 2579

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

1 3852

What is a clustered index?

1 7021




When will you chose to run RUNSTATS?

1 4547

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

3 3226

What is meant by a unit of recovery?

1 2136

What is CHECK PENDING ?

4 8509

What is a thread?

3 2723

What is filter factor?

2 6086

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

1 4587


Post New DB2 Questions






Un-Answered Questions { DB2 }

How to test SQL -911 error while developing COB-DB2 program

4339


How can you get the number of rows impacted by the last executed query?

138


what is the sqlcode -501

6391


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

6194


How to fetch the uncommited data from table ?

137


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 ?

227


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?

726


Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

1290


What will happen, while trying to close the closed cursor.

219


what is utility for parm lib

646


If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

551


in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert

83


by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

4055


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

2454


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

919