DB2 Interview Questions
Questions Answers Views Company eMail

what is the process of precompiler?

2 8964

What is buffrpool? Where we use it ?

Tesco,

2 8019

what is Runstats? Whem will u choose to runatats?

Danske,

1 6978




what is REORG? what is the use?

4 7812

What is the difference between a package and a plan?

Mphasis, L&T, Infosys,

6 34065

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 3510

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

1 5170

What is a clustered index?

1 8479




When will you chose to run RUNSTATS?

1 5625

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

3 4265

What is meant by a unit of recovery?

1 2959

What is CHECK PENDING ?

4 10350

What is a thread?

3 3566

What is filter factor?

2 6979

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

1 5626


Post New DB2 Questions






Un-Answered Questions { DB2 }

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?

4563


ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

704


is it compulsory commitment control in journal?

1180


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.

1479


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

4938






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

925


what is the sqlcode -501

7313


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

1896


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?

4680


what is the responsibility of the construction superintendent

823


before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

932


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?

1005


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

1097


I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

1825


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

1036