Where is the access path logic created by the DB2 Optimizer
stored?



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

Post New Answer

More DB2 Interview Questions

What is db2 plan table?

0 Answers  


What is IMAGECOPY ?

6 Answers  


What is a base table?

2 Answers  


What is alias in db2?

0 Answers  


What's the maximum number of volumes that can be added to a STOGROUP?

1 Answers   IBM,


What is ibm db2 used for?

0 Answers  


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. 

2 Answers   RBS,


What is db2 purescale?

0 Answers  


wht happens if we close cursor with cursor with hold option?

3 Answers   Valtech,


How many sub queries can you combine together ?

4 Answers   IBM,


how can i pull up a query which was previously stored in qmf

3 Answers  


What is runstats and reorg in db2?

0 Answers  


Categories