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 |
How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?
Can we install 2 different versions of Db2 on same mainframe?
How and when does the db2 enforces the unique key?
How to define the data items to receive the fetch items for the SQL?
how to u check the query is executing or not ?where will u check for sqlcode ?
What should be specified along with a cursor in order to continue updating process after commit?
Can a array declared with an index be displayed(readable format) in spool?
How to find last record before record through SQLRPGLE?
What is the difference between bind and rebind in db2?
What is the syntax for FETCH in DB2 ?
What is referential integrity?
wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?