What is Skeleton cursor table (SKCT)?
Answers were Sorted based on User's Feedback
Answer / vat
Contains information about access paths and the internal
form of the SQL for an application plan. Entries in this
table are made when a plan is bound (BIND PLAN) and deleted
when a plan is freed (FREE PLAN). This table is also loaded
into memory at execution time
Is This Answer Correct ? | 3 Yes | 0 No |
What is meant by a unit of recovery?
What is the difference between CS and RR isolation levels?
How can you count the number of rows from a table tab?
What is host variable?
Compare a subselect to a join?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
How can the duplicate values be eliminated from db2 select?
what needs to be done if a table is in copy pending / check pending status?
what are stage one indexable predicates?
What is the use of DELGEN in DB2? Can we Write the program with out using it?
Can SQL statements/queries be included in a copybook?
Request to database but database is not available so what is was abend is raised?