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 |
How many databases can be created inside an instance in db2 ?
I have some 3 particular fields ..i want to know which all tables have those 3 fields. Is there any way to identify.. can we know by quering system tables..
What is ibm db2 connect?
How to handle null values in db2
What is dpf in db2?
Suppose there are many duplicate records in a Db2 table. What is the query to retrive only duplicate records?
Mention and explain the contention situations caused by locks?
How can we define a table? How can we apply SEARCH ALL on it ?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What do you mean by NOT NULL? When will you use it?
What is db2 and what is the use of db2 optimizer?
What language is db2 written in?