What is a PLAN table? How will you use it? Give the various
fields of PLAN table?
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
Explain the contention situations caused by locks?
How can the duplicate values be eliminated from db2 select?
What is load utility in db2?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What is the syntax for seeing the columns and data types of a table in the db2 database?
What are the different types of base tables?
What is bind in db2?
What is null in db2?
What is a bind in db2?
List out the buffer pools in db2
What is copy pending status in db2?
What is the physical storage length of timestamp data type?
What are db2 objects?
What is sqlca?
What is clone table?