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
- 4358 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 copy pending and check pending in db2?
When the like statement is used?
How to rename a table in DB2 ?
Explain about open switch business continuity software?
Mention and explain the contention situations caused by locks?
How Plan is created while executing the query using SPUFI?
What are the bind parameters ibm db2?
What is a Foreign Key?
0 Answers Tavant Technologies, Zensar,
What information is contained in a SYSCOPY entry?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
Why use RUNSTAT Utility?
What is check constraint in db2?
COBOL 
