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


Please Help Members By Posting Answers For Below Questions

Name the lockable units in DB2?

660


Mention the different locking levels that are available in db2.

635


Explain about rct.

643


What is collection in db2 bind?

569


What is dpf in db2?

660






Which isolation level provides maximum concurrency?

658


What does db2 stand for?

594


What is precompiler in db2?

582


How do I create a view in db2?

597


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?

1930


Explain in detail about buffer manager and its functionalities?

556


What is the difference between db2 and oracle?

668


Can we delete records from view?

553


Outputs of explain are with matchcols = 0. What does this signify?

613


How to access db2 tables in mainframe?

611