Where are plans stored?

Question Posted / guest

2 Answers
7245 Views
I also Faced
E-Mail Answers

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

How to create backup table in db2?

0 Answers

What is copy book?

1 Answers Thomson Reuters,

I have some 3 particular fields ..i want to know which all tables have those 3 fields. Is there any way to identify.. can we know by quering system tables..

5 Answers CTS,

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

0 Answers

what is consistency token

3 Answers

What is scrollable cursor in db2?

0 Answers

What are host variables in db2?

0 Answers

my project is insurance management system,how to explain my work environment in interview?

2 Answers CGI, Value Labs,

what is commit & rollback? When and where is used while compiling a cobol-db2 program?

2 Answers

Which catalog tables contain authorization information?

1 Answers

What is a db2 table?

0 Answers

What is the self-referencing constraint?

2 Answers

For more DB2 Interview Questions Click Here