What is a PLAN table? How will you use it? Give the various
fields of PLAN table?
Answer Posted / sneha
Plan is an access path for your program to access the DB2 table. During precompilation process, the SQL queries are converted into executable statements and stored in DBRM (Database Request Module). This DBRM will have a consistency token. During the bind step, this DBRM will be read and a plan will be produced. Few important parameters we include in Bind job is ISOLATION LEVEL ( how one transaction needs to be separated from another transaction which does some data modification on the table), QUALIFIER etc.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are union and union all?
What is a system catalog table in db2?
Is db2 a mainframe?
How to find the number of rows in a db2 table?
What is drop table?
What is the maximum size of a char data type in db2?
What is lock escalation in db2?
How to check last update on table in db2?
What is meant by dclgen?
What is dbrm? What it contains?
How do you concatenate the firstname and lastname from emp table to give a complete name?
What are the prerogatives?
On which levels locks can be applied?
What is dclgen (declaration generator)?
Differentiate between cs and rr isolation levels? Where do you specify them?