Explain in brief how does db2 determine what lock-size to use?
What is Reorg Recovery? when will you run it?
What does db2 plan contain?
WHAT IS NULL INDICATOR ? WERE IS THIS USED? AND IF IT IS USED IN FILES CONCEPT? HOW DO WE USE IT?
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 .....
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.
Can we install 2 different versions of Db2 on same mainframe?
what is the input to PLAN? what is the input to DBRM?
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?
Where would you find information about the type of database authority held by the user?
How do we specify index to include or not during bind process.
What is db2 command?
How do I delete a table in db2?