Explain in brief how does db2 determine what lock-size to use?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More DB2 Interview Questions

What is Reorg Recovery? when will you run it?

2 Answers  


What does db2 plan contain?

0 Answers  


WHAT IS NULL INDICATOR ? WERE IS THIS USED? AND IF IT IS USED IN FILES CONCEPT? HOW DO WE USE IT?

2 Answers   IBM,


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

0 Answers  


a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.

3 Answers  


Can we install 2 different versions of Db2 on same mainframe?

3 Answers  


what is the input to PLAN? what is the input to DBRM?

4 Answers  


can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?

1 Answers  


Where would you find information about the type of database authority held by the user?

2 Answers  


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

0 Answers   Satyam,


What is db2 command?

0 Answers  


How do I delete a table in db2?

0 Answers  


Categories