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

Where are plans stored?

Question Posted / s

Answer Posted / s

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

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What do you mean by cursor?

995

What are the contents of a dclmgen?

1136

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1189

i want to maintain uniqueness on pdf without make lf??????????

2161

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

1093

What is a db2 table?

1027

How do I import data from excel to db2?

1079

What is the maximum number of columns in a db2 table?

1293

How and when does the db2 enforces the unique key?

1089

What is the role of data manager in the db2 database?

1112

Name the lockable units in DB2?

1133

What is the difference between cursor stability and repeatable read isolation levels?

1187

Are view updateable?

1052

How many databases can be created inside an instance in db2 ?

1043

What parameters are used to control the free space in DB2?

1063