What is a PLAN table? How will you use it? Give the various
fields of PLAN table?
- 1 Answers
- 4492 Views
- Accenture, I also Faced
- E-Mail Answers
Answer / 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 |
What is package versioning? Please give an example.
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What is a result table?
On which levels locks can be applied?
Where is the access path logic created by the DB2 Optimizer stored?
One program calling 5 subprograms, its a cobol db2 program, after precompilation how many plans and packages will created?
What is -904 sql code? How to resolve it?
how to unload different table data into different gdg files/ vsam files.
How many buffer pools are there in DB2?
What is the use of reorg in db2?
What is clone table?
Explain an outer join?
COBOL 
