What is a DBRM, PLAN ?

Question Posted / guest

3 Answers
17064 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is a DBRM, PLAN ?..

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