What is a DBRM, PLAN ?
Answers were Sorted based on User's Feedback
Answer / mehdee
The above answer is right, but the 2nd part should change
to: PLAN is an executable module containing the access path
logic to one or more DBRMs and packages.
| Is This Answer Correct ? | 13 Yes | 2 No |
Answer / 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 |
What is CHECK PENDING ?
What is the purpose of the DSNC transaction ?
What is Reorg Recovery? when will you run it?
What is a buffer in memory?
What is cursor stability?
Explain in detail about buffer manager and its functionalities?
What is reorg in DB2
What is db2 purescale?
What is meant by explain?
Explain the benefits you can get from mainframe connect?
Explain dclgen.
Are views updateable?