Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

What is a DBRM, PLAN ?

Question Posted / guest

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

What is CHECK PENDING ?

5 Answers  

What is the purpose of the DSNC transaction ?

1 Answers  

What is Reorg Recovery? when will you run it?

2 Answers  

What is a buffer in memory?

0 Answers  

What is cursor stability?

1 Answers  

Explain in detail about buffer manager and its functionalities?

0 Answers  

What is reorg in DB2

3 Answers   Virtusa,

What is db2 purescale?

0 Answers  

What is meant by explain?

0 Answers  

Explain the benefits you can get from mainframe connect?

0 Answers  

Explain dclgen.

0 Answers  

Are views updateable?

0 Answers  

For more DB2 Interview Questions Click Here
Categories