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

How to resolve -502 sql code in DB2?

2 Answers   Cap Gemini,


What is syscat in db2?

0 Answers  


What is innodb buffer pool?

0 Answers  


List out the three types of page locks that can be held.

0 Answers  


What is DCLGEN ?

3 Answers  


I am getting a error multiple row fetched while executing a Cobol-DB2 program.How can I solve it without using a cursor.

8 Answers  


How to connect to db2 database from windows command line?

0 Answers  


Can you use max on a char column?

0 Answers  


What's the maximum number of characters that a tablename can have?

3 Answers  


I have a main program (A) where we delete some rows in table in a cursor, and we commit it in sub program(B). What will happen - will we get an error or not?

2 Answers  


Hi this is sures. i need to practice the ibm mainframes.could u telme how can i get userid from IBM.how much cost they will collect for one user id.can send me the details please.thanq

2 Answers  


What are iseries servers?

0 Answers  


Categories