What else is there in the PLAN apart from the access path?



What else is there in the PLAN apart from the access path?..

Answer / s

The Plan contains the executable SQL code(if DBRMs are
directly bound to the plan) with its access path as well as
the consistency token that will be checked against the
contoken in the load module at execution time.

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More DB2 Interview Questions

How do I add a column to a table in db2?

1 Answers  


Hi , I am posting some interview ques . what is the use of cursors ? what is the diff between select and cursor ? bith are used for data retrival .. rite?

2 Answers   Deloitte,


is it compulsory commitment control in journal?

1 Answers   TCS,


What is dbrm?

1 Answers  


If the main program has only cobol statements and subprogram has the db2 statements what is the procedure for precompilation. for which program we need to do the precompilation

1 Answers   IBM,


What are the Isolation levels possible ?

5 Answers  


when we are trying to update db2 rows. if the program abends . how we will know that the last successful update row was

5 Answers   IBM,


What is runstats and reorg in db2?

1 Answers  


Define sqlca.

1 Answers  


How to resolve the -305 error code in DB2? And also please let me know, how to resolve the db2 error codes.

7 Answers   TCS,


What is the STOSPACE Utility used for?

1 Answers  


When would you prefer to use VARCHAR?

3 Answers  


Categories