DB2 Interview Questions
Questions Answers Views Company eMail

what is the process of precompiler?

2 7496

What is buffrpool? Where we use it ?


2 6869

what is Runstats? Whem will u choose to runatats?


1 5661

what is REORG? what is the use?

4 6765

What is the difference between a package and a plan?

Mphasis, L&T, Infosys,

6 31385

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 2994

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

1 4404

What is a clustered index?

1 7715

When will you chose to run RUNSTATS?

1 5027

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

3 3658

What is meant by a unit of recovery?

1 2515


4 9412

What is a thread?

3 3092

What is filter factor?

2 6518

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

1 5133

Post New DB2 Questions

Un-Answered Questions { DB2 }

can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well


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


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


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?


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.


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.


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 ?


How can you validate Sql errors during cursor operation in db2 pgms and where do you code?


what is utility for parm lib


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


i want to maintain uniqueness on pdf without make lf??????????


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?


what is the sqlcode -501


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


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