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 |
Is DECLARE TABLE in DCLGEN necessary? Why it used?
What does DML stand for and what are some examples of it?
Suppose if I need to update a column, how you do that using cursor?
What is lock escalation?
What are the full forms of spufi and dclgen and why are they used?
What is the difference between bind and rebind in db2?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
What is the result of open cursor statement?
What is the usage of open cursor command?
What is meant by a unit of recovery?
How does DB2 determine what lock-size to use?
Give the name of some fields form sqlca.