What is a PLAN table? How will you use it? Give the various
fields of PLAN table?



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

Post New Answer

More DB2 Interview Questions

What is the STOSPACE Utility used for?

1 Answers  


What is DCLGEN?

2 Answers  


how do we solve soc 7 and soc4 ?

3 Answers   Tech Mahindra,


wht is d/f between union and joins ?

2 Answers  


What is explain plan in db2?

0 Answers  






what is datacom db?

2 Answers   CSC,


what is the use of commit ? and what is the syntax?

2 Answers   Deloitte,


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?

8 Answers  


What does DSNDB07 database do?

2 Answers  


Explain about rct.

0 Answers  


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..

1 Answers   HSBC,


What is db2 catalog database?

0 Answers  


Categories