Where is the access path logic created by the DB2 Optimizer
stored?
Answer Posted / s
It is stored as bound plans/packages in the DSNDB01
directory in SKCT02, SKPT01 tablespaces.
Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
Explain the contention situations caused by locks?
What is bind package and plan in db2?
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.
What is the syntax for creating a table in the db2 database?
What are the different types of base tables?
List down the types of triggers in the db2 database?
How do you stop a db2 database in linux?
Which components manage deadlocks in db2?
What is ibm db2 client?
Explain the contents that are a part of dclgen.
How would you find out the total number of rows in a db2 table?
What are the full forms of spufi and dclgen and why are they used?
Can there be more than one cursor open for any program?
What is the physical storage length of timestamp data type?
What is data manager?