Clicky
Skip to Content
Custom Search

Reply to comment

Anonymous
DBRM: It is Data Base Request

DBRM: It is Data Base Request Module which contains the extracted SQL query from the source code.

Plan: It contains the executable sql code and access path.

Package: It has the access path to access the table for its sql. To execute a DB2 program we need to have Plan but in some case we do have a package to reduce some complexity, like if a program has 4 sub program and if any one undergoes changes then we can bnid only the respective package used each package will have one DBRM and each DBRM will be created for each program. It reduces the cost of larger plan bind.

Collection: Group of packages are called collections.

Reply

  • Allowed HTML tags:
      1. Lines and paragraphs break automatically.

    More information about formatting options

    CAPTCHA
    This question is for testing whether you are a human visitor and to prevent automated spam submissions.

Navigation

Click the +1 button  below to share it with your friends and colleagues

 

Share this if you liked it!

 

Disclaimer



Number of Registered users 714
Theme by Dr. Radut.