Answer Posted / 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 View All Answers
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What is dbrm? What it contains?
What is check constraint in db2?
What is the difference between dbm cfg and db cfg file in db2 ?
What is package in db2 mainframe?
What are union and union all?
What is innodb buffer pool?
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 is a storage group (stogroup)?
How to execute stored procedure in db2 command editor?
Explain various types of locks in db2?
What is db2 stogroup?
What is the use of reorg in db2?
List out the three types of page locks that can be held.
What parameters are used to control the free space in DB2?
