What is a DBRM, PLAN ?

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


Please Help Members By Posting Answers For Below Questions

What is a bind card?

679


What is data manager?

603


What is an instance database?

598


What is an instance in db2?

561


How do I import a csv file into db2?

558






How to execute stored procedure in db2 command editor?

528


How do I optimize a query in db2?

613


What is commit in db2?

591


What are packages in db2?

593


Is db2 a database?

572


In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

577


What is a page in db2?

608


What is the clustering index in the db2 database?

580


Is db2 a mainframe?

581


Give the name of some fields form sqlca.

609