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 buffer pool?
How to check last update on table in db2?
Mention the different locking levels that are available in db2.
Is the primary key a clustered index?
Explain package in db2 and its advantages?
What is blu acceleration in db2?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
Who uses db2?
What is view db2?
What is cobol db2?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What is concurrency?
What is the default page size of buffer pools?
How to access db2 tables in mainframe?