It is stored as bound plans/packages in the DSNDB01 directory in SKCT02,

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

Question Posted / s

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

Please Help Members By Posting Answers For Below Questions

Explain about dbrm.

1010

How do I copy a table in db2?

971

What is dclgen in db2?

1100

What is the difference between cursor stability and repeatable read isolation levels?

1142

How would you find out the total number of rows in a db2 table?

1016

What are db2 tables?

1069

Which command is used to remove all rows from a table?

1067

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

1114

What is buffer pool?

1051

How do you eliminate duplicate values in db2?

1126

How do I connect my db2 database to ibm?

1008

Define check constraint.

1046

If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

1998

Which isolation level provides highest data integrity?

1070

Outputs of explain are with matchcols = 0. What does this signify?

1018