what is the input to PLAN?
what is the input to DBRM?
Answer Posted / anil reddy
DBRM-Caontains SQL statments seperated from your host
laguae bt Precompiler.
PLAN-Is the generated by BIND process , which will contain
Excutale cde for SQL statements in the DBRM.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is reorg?
What is dbrm? What it contains? When it will be created?
What is dpf in db2?
What is the role of data manager in the db2 database?
What is data manager?
Explain about dbrm.
How to access db2 tables in mainframe?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What is bind in db2?
What is declare cursor?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
Which component is responsible for db2 startup and shutdown?
What is the difference between plan and package in db2?
Explain how can you do the explain of a dynamic sql statement?
What is db2 optimizer?