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
- 4367 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 ibm db2 client?
What is image copy?
How do you select a row using indexes in db2?
What is the self-referencing constraint?
What is meant by index cardinality?
What is cursor stability?
Why PS file called Physical seqential file?How to sore data in sequential file and ESDS file? What is the use of DBRM,PLAN,package and Collection.
If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?
How to test SQL -911 error while developing COB-DB2 program
What is buffer pool in the db2 database?
What is the SQL Communications Area and what are some of its key fields?
Is ibm db2 free?
COBOL 
