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

when i am trying to update a table having 1000 rows. the program abends.how we will come to know the last successful updated row was. we are not using any commit operations

3 Answers   IBM,


is it possible to get -811 error when you use cursors. why?

2 Answers   IBM,


i want to delete 20th million record how ?

4 Answers   IBM,


Explain about rct.

0 Answers  


What is QUIESCE?

2 Answers  






What are the rules for db2 programming?

0 Answers  


File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

0 Answers   Infosys,


What is JOIN and different types of JOIN.

2 Answers   IBM,


What is the use of commit in db2?

0 Answers  


What is a DB2 access path?

1 Answers  


Is db2 relational database?

0 Answers  


What is runstats utility in db2?

0 Answers  


Categories