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
- 4336 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
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What is runstats utility in db2?
What is copy pending status in db2?
What is image copy in db2?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
what is db2 restart?
List out the three types of page locks that can be held.
What is null indicator in cobol db2?
Define db2 and its databases?
What is a db2 collection?
What is the difference between nvl and coalesce?
What is db2 optimizer?
What is cursor with hold option in db2?
What is db2 stogroup?
Define db2.
