What is a DBRM, PLAN ?

Answers were Sorted based on User's Feedback



What is a DBRM, PLAN ?..

Answer / sunil1405

database rquest module(DBRM) , they are created after the
precompilation is performed. It contains executable host
SQL statements.

Plan is the output of bind process, of which the inout to
bind is DBRM. Plan contains host SQL statements.

Is This Answer Correct ?    16 Yes 3 No

What is a DBRM, PLAN ?..

Answer / mehdee

The above answer is right, but the 2nd part should change
to: PLAN is an executable module containing the access path
logic to one or more DBRMs and packages.

Is This Answer Correct ?    13 Yes 2 No

What is a DBRM, PLAN ?..

Answer / 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

More DB2 Interview Questions

Explain an outer join?

1 Answers  


What do you mean by rollback?

0 Answers  


What is correlated subquery?

1 Answers  


What is sqlcode -811?

7 Answers   Accenture, CTS, TCS,


What is db2 purescale?

0 Answers  






What is drop table?

0 Answers  


I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

2 Answers  


What is the syntax for seeing the columns and data types of a table in the db2 database?

0 Answers  


What is the difference between primary key & unique index ?

6 Answers   Patni, Temenos,


File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

0 Answers   Infosys,


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?

0 Answers   HeadStrong,


What is RUNSTATS?

3 Answers  


Categories