What is a PLAN table? How will you use it? Give the various
fields of PLAN table?
- 1 Answers
- 3593 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 REORG? what is the use?
What is the difference between IN subselects and EXISTS subselect?
What is the difference between cursor stability and repeatable read isolation levels?
What is meant by explain?
How connect db2 database to datastage?
in a table consist of 1000 records among that i was updated 145 record how could i know that ..list of recently updated record's and where could i see those updated record's....pls help me out....
what is Runstats? Whem will u choose to runatats?
wht are the restrictions for union ?
Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?
What is copy pending status in db2?
What is the self-referencing constraint?
How can record locking be achieved in those DB2 versions which do not support it?
COBOL 
