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 |
What is db2 plan table?
What is IMAGECOPY ?
What is a base table?
What is alias in db2?
What's the maximum number of volumes that can be added to a STOGROUP?
What is ibm db2 used for?
Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 tables EMP1 and EMP2 with same structure defined in two different DB2 qualifiers QUAL1.EMP1 and QUAL2.EMP2 now during first 15 days we want to use QUAL1.EMP1 and rest of the days QUAL2.EMP2 how will we do this. We can create a single program and a single load for this program.
What is db2 purescale?
wht happens if we close cursor with cursor with hold option?
How many sub queries can you combine together ?
how can i pull up a query which was previously stored in qmf
What is runstats and reorg in db2?