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
Name the lockable units in DB2?
Mention the different locking levels that are available in db2.
Explain about rct.
What is collection in db2 bind?
What is dpf in db2?
Which isolation level provides maximum concurrency?
What does db2 stand for?
What is precompiler in db2?
How do I create a view in db2?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
Explain in detail about buffer manager and its functionalities?
What is the difference between db2 and oracle?
Can we delete records from view?
Outputs of explain are with matchcols = 0. What does this signify?
How to access db2 tables in mainframe?