What is a DBRM, PLAN ?

db2 sql interview questions

Moderator: Moderator Group

Post Reply
User avatar
Krishna
Site Admin
Posts: 1052
Joined: Fri Jan 27, 2006 7:50 am

What is a DBRM, PLAN ?

Post by Krishna » Sun Mar 29, 2009 11:03 pm

What is a DBRM, PLAN ?

User avatar
Krishna
Site Admin
Posts: 1052
Joined: Fri Jan 27, 2006 7:50 am

Post by Krishna » Sun Mar 29, 2009 11:03 pm

DBRM: DataBase Request Module, has the SQL statements extracted from the host language program by the pre-compiler.

PLAN: A result of the BIND process. It has the executable code for the SQL statements in the DBRM.

ramana murthy
Member
Posts: 10
Joined: Thu Jul 21, 2011 1:34 pm

Post by ramana murthy » Wed Aug 24, 2011 2:02 pm

Is it database request module or database resource module?
can you plz clarify me?

DikDude
Moderator
Posts: 1001
Joined: Fri Jul 22, 2011 8:39 am
Location: usa

Post by DikDude » Wed Aug 24, 2011 9:31 pm

DataBase Request Module. . .

Suggest you become familiar with the DB2 documentation. . .
Have a good one

vsk
Member
Posts: 3
Joined: Wed Feb 27, 2013 10:02 pm

Post by vsk » Mon Mar 04, 2013 4:07 pm

how to add package version id to DBRM ?

Anuj Dhawan
Moderator
Posts: 1625
Joined: Sat Aug 09, 2008 9:02 am
Location: Mumbai, India

Post by Anuj Dhawan » Tue Mar 05, 2013 5:22 pm

vsk - If you've a new question, please start a new thread.

The original post is around 4 years old and the latest, before yours, is at least one-&-half-year old. Don't tail-gate, please.
Regards,
Anuj

NicC
Active Member
Posts: 650
Joined: Sun Jul 24, 2011 5:27 pm
Location: Down on the pig farm

Post by NicC » Wed Mar 06, 2013 9:32 am

And note that these are interview questions that YOU were asked. You should supply the question and your answer so that people can say "OK" or "Wrong and the correct answer is..."
Regards
Nic

Anuj Dhawan
Moderator
Posts: 1625
Joined: Sat Aug 09, 2008 9:02 am
Location: Mumbai, India

Post by Anuj Dhawan » Wed Mar 06, 2013 1:15 pm

Ditto!
Regards,
Anuj

academyindia4

Topic deleted by Admin

Post by academyindia4 » Wed Feb 03, 2016 10:49 pm

<< Content deleted By Admin >>

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others