What is a PLAN table? How will you use it? Give the various
fields of PLAN table?
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 if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.
How will you delete duplicate records from a table?
What is the difference between bind and rebind in db2?
What is collection in db2 bind?
What is a NULL value? What are the pros and cons of using NULLS?
What is sqlca?
What will happen, while trying to close the closed cursor.
What is the latest version of ibm db2?
cursor with hold explain ?
What is dbrm? What it contains? When it will be created?
What is netezza database?
What do you mean by storage group (stogroup)?