Where are plans stored?

Question Posted / guest

2 Answers
7148 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

Hi , I am posting some interview ques . what is the use of cursors ? what is the diff between select and cursor ? bith are used for data retrival .. rite?

2 Answers Deloitte,

what is + sign and -ve sign for sql code ?

1 Answers TCS,

What is a correlated sub query?

2 Answers

Can I use LOCK TABLE on a view?

1 Answers

How to run db2 command in windows?

0 Answers

Is ibm db2 open source?

0 Answers

Define db2.

0 Answers

how to fetch multiple records without using cursor

14 Answers HCL,

can we drop column from a table

7 Answers INDUS,

What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.

1 Answers Cap Gemini,

What is an inner join, and an outer join ?

1 Answers CTA,

What is the function of buffer manager?

1 Answers

For more DB2 Interview Questions Click Here