Answer Posted / kundan kumar
DBRM :-database request module(DBRM) , they are created after the
pre-compilation is performed. It contains parsed SQL statements.
PLAN :- PLAN is an executable module containing the access path
logic to one or more DBRMs and packages created after bind process .
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is the responsibility of the construction superintendent
What is the usage of open cursor command?
What is access path in db2?
How to execute stored procedure in db2 command editor?
What is explain plan in db2?
Explain what are the various isolation levels possible?
What is the maximum size of a char data type in db2?
Explain about cursor stability?
What is cascading rollback?
How to find the maximum value in a column in the db2 database?
Mention the downsides of page level lock.
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What are the full forms of spufi and dclgen and why are they used?
What is a bind in db2?
