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 STOSPACE Utility used for?
What is DCLGEN?
how do we solve soc 7 and soc4 ?
wht is d/f between union and joins ?
What is explain plan in db2?
what is datacom db?
what is the use of commit ? and what is the syntax?
Is it possible to update a primary key value? If not, what is the error code given? If yes, can more than 1 primary key column be updated at a time?
What does DSNDB07 database do?
Explain about rct.
Could you please let me no the query for below I have table name xyx under this there is column name called employee name which starts from 100th column ends 120th column,now i want to replace only column from 101 to 104 which contains ABCS to replace with PQRS for all records which comes beetween 101 to 104 ..how to write query for this..
What is db2 catalog database?