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
- 4198 Views
- Accenture, I also Faced
- E-Mail Answers
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
Comment whether the cursor is closed during commit or not.
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
Which isolation level provides highest data integrity?
Define declaration generator (dclgen).
List out the data types available.
Define check constraint.
How will you return the number of records in table?
What are the benefits of using the db2 database?
What are the uses of db2 optimizer?
what is the sqlcode -501
what is db2 restart?
Which components manage deadlocks in db2?
Explain the function done by data manager?
List some fields from sqlca?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
