What is a PLAN table? How will you use it? Give the various
fields of PLAN table?
- 1 Answers
- 3414 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 |
Explain about cursor stability?
What is a Foreign Key?
0 Answers Tavant Technologies, Zensar,
What are the various data types available in db2?
What is with ur in db2?
Is there any advantage to denormalizing DB2 tables?
What is reorg in database?
What is explain plan in db2?
What is a db2 tablespace?
What is QUIESCE?
What is the physical storage length of date data type?
Which catalog table stores referential constraints?
What technique is used to retrieve data from more than one table in a single SQL statement?
COBOL 
