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 a synonym? How is it used?

2 Answers  


When DB2 connection fails, will online program work or give errors.

1 Answers   Virtusa,


What is a predicate?

1 Answers  


How is deadlock resolved?

0 Answers  


Explain the use of the WHERE clause?

1 Answers  






How to define the a field which accepts value till 99999.99 in db2

3 Answers  


What is blu acceleration in db2?

0 Answers  


What do you mean by NOT NULL? When will you use it?

3 Answers  


PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PACKAGE?

2 Answers   Tech Mahindra, Wipro,


What is the difference between a package and a plan?

6 Answers   Infosys, L&T, Mphasis,


before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

0 Answers   IBM,


how to resolve -805. give clear explination for that

2 Answers   IBM,


Categories