Interested to Buy Any Domain ? << Click Here >> for more details...
What is a PLAN table? How will you use it? Give the various
fields of PLAN table?
- 1 Answers
- 4202 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 |
Is ibm db2 open source?
What is db2 optimizer?
What does the REORG Utility do?
How can we read records for specific member in CL? AND rpg?
is it possible to get -811 error when you use cursors. why?
What is db2?
In which column of which DB2 catalog would you find the length of the rows for all tables?
What is a correlated sub query?
What is the purpose of the WHENEVER statement?
Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?
What is load replace in db2?
what is differnece between DROP TABLE & DELETE TABLE .
COBOL 
