What Is The Diff Bet Plan,package,dbrm

  • 15 Mar, 2012

    Plan is generated when you compile the DB2-SQL program.This plan is stored in the DBRM and binded to database as packages. (stored in syscat.syspackages - pkgname)DBRM: Data base request module is generated by precompiler which contains the sql statements which are separated from the source program.PACKAGE: By binding the DBRM package is generated.Package contains the internal structure of the original sql statements.PLAN: It is the combination of packages that are bind to form a PLAN.

    Comments Received:
    Please give your suggestions and feedback:

2009-2016 downloadmela.com. All rights reserved.