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

What is the use of dclgen in db2?

1082

What is the difference between drop table and delete table?

1203

How can the duplicate values be eliminated from db2 select?

1101

What is db2 and what is the use of db2 optimizer?

1056

How to access db2 tables in mainframe?

1051

What are the contents of dclgen?

1103

What is db2 bind process?

1236

What are the two types of logging in the db2 database? Explain them.

1071

What types of tables are there in the db2 database?

1052

How many databases can be created inside an instance in db2 ?

1029

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2210

What is the difference between cursor and select statement?

1097

What is an instance database?

1048

Mention the various locks that are available in db2.

1035

What is dbrm?

1104