What is Skeleton cursor table (SKCT)?

Question Posted / guest

2 Answers
14398 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is Skeleton cursor table (SKCT)?..

Answer / s

Skeleton cursor table contains the bound plan.

Is This Answer Correct ?

4 Yes

1 No

What is Skeleton cursor table (SKCT)?..

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

Post New Answer

More DB2 Interview Questions

how to fetch first 100 rows in db2

2 Answers IBM,

how to resolve -818 error. how to see timestamp token in load module and plan

4 Answers IBM,

Which are the db2 tools to protect integrity of the database?

0 Answers IBM,

What's The Percentage Free Space ?

0 Answers IBM,

what is the use of cursors?

3 Answers iGate,

before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

0 Answers IBM,

How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?

1 Answers

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?)

2 Answers

What are foreign keys?

1 Answers

what is a plan and how do you refer the plan in the program?

2 Answers Xansa,

On which levels locks can be applied?

0 Answers

How do I import data from excel to db2?

0 Answers

For more DB2 Interview Questions Click Here