Where are plans stored?
Answers were Sorted based on User's Feedback
Answer / s
The Bound plans are stored in the SKCT tablespace in
DSNDB01 directory.
| Is This Answer Correct ? | 2 Yes | 1 No |
What is index cardinality?
What is declare cursor?
I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,which cost is second maximum in the table?
Which components manage deadlocks in db2?
What is error -818 in db2. where can you find the timestamp of the DBRM and the source code.( precompile puts the timestamp on dbrm and source code correct?)
What is a trigger in the db2 database?
Before you give the explain statement, what are the prerogatives?
What is the advantage in De-normalizing tables in DB2?
What is null value in db2?
How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.
What is isolation level in db2?
What is a DB2 bind?