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 is the use of cursors?
what is diffrence b/w file-aid tool and file-aid utility???
How many databases can be created inside an instance in db2 ?
For Read Stability locks are not applicable for phantoms, What is Phantoms?
Mention data types used in db2 ?
What are some characteristics of columns that benefit from indexes?
why we create view.
What is a root page?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
What is the SQL Communications Area and what are some of its key fields?
What is IMAGECOPY ?
Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?