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
Explain about dbrm.
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
What happens in bind step in a db2 program?
Mention data types used in db2 ?
Why do we bind in db2?
What is dbrm in db2 database?
Comment whether the cursor is closed during commit or not.
What os does db2 run on?
What is load utility in db2?
How to create backup table in db2?
What is an instance database?
Is db2 a mainframe database?
What is dpf in db2?
Mention the location where the output received from explain statement is stored.
How many types of page locks can be held in db2?