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
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?
Explain correlated sub-queries.
Explain about cursor stability?
What is a db2 schema?
What are bind parameters in db2?
What is dbrm? What it contains?
Are views updateable?
What is image copy in db2?
Why db2 is called db2?
On which levels locks can be applied?
Can we update view in db2?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What is the physical storage length of timestamp data type?
How to check table size in db2 sap?
How to view db2 table structure?