Where are plans stored?

Answers were Sorted based on User's Feedback



Where are plans stored?..

Answer / anand

SYSIBM.SYSPLAN

Is This Answer Correct ?    6 Yes 0 No

Where are plans stored?..

Answer / s

The Bound plans are stored in the SKCT tablespace in
DSNDB01 directory.

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More DB2 Interview Questions

What is the use of db2?

0 Answers  


My SQL is not performing well. Describe how will you fine tune it?

1 Answers   Accenture,


Which isolation level provides highest data integrity?

0 Answers  


What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.

3 Answers   IBM,


what is static sql? what is dynamic sql? Give me details

3 Answers  






How to fetch the last row from the table in SQL (db2)?

0 Answers  


What is db2 bind?

0 Answers  


What is the difference between dbm cfg and db cfg file in db2 ?

0 Answers   MCN Solutions,


Which are the db2 tools to protect integrity of the database?

0 Answers   IBM,


How to find primary key of a table in db2?

0 Answers  


List down the data types in the db2 database.

0 Answers  


What does runstats do in db2?

0 Answers  


Categories