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 |
Give the name of some fields form sqlca.
What is a DB2 bind?
Can we able to find all the Table names under a Particular Plan?
What are foreign keys?
What is db2 and what is the use of db2 optimizer?
How to execute stored procedure in db2 command editor?
Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.
what is db2 restart?
When do you specify the isolation level? How?
What is meant by concurrency?
how can you save the query in QMF?IS IT POSSIBLE OR NOT.IF POSSIBLW HOW?
How to get the ddl of a table in db2?