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 |
Hi Team, Please tell me, If i don't declare the cursor in the program and i have given open and fetch and close, then what error will get.
How to access db2 tables in mainframe?
Explain transactions, commits and rollbacks in DB2.
What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?
What happens to the PLAN if index used by it is dropped?
what are the SQL codes u freequently got?
How can you display the current date & current time ?
what is the process of precompiler?
what's the error code for Unique Index Violation?
how to resolve -805. give clear explination for that
Is there any advantage to denormalizing DB2 tables?
What is explain plan in db2?