Where is the access path logic created by the DB2 Optimizer
stored?
Answer / s
It is stored as bound plans/packages in the DSNDB01
directory in SKCT02, SKPT01 tablespaces.
Is This Answer Correct ? | 4 Yes | 2 No |
Which components manage deadlocks in db2?
what is difference between Static call and Dynamic call? How does it function?
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?
What do you mean by rollback?
What is reorg in database?
What are db2 tables?
What will the COMMIT accomplish?
Are views updatable ?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
Mention the various locks that are available in db2.
How to solve S0C7 abend with out using DISPlay in 10 mins?
Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?