What is a db2 package?









What is a package?

A package is a single, bound DBRM which contains optimized access paths to DB2.  Packages are the ouput of “Bind Package” command which takes DBRM as input. There can be one DBRM per package.  Once the package is formed using the DBRM it can be fed to the “Bind Plan” command to obtain application Plan.

; ; ; ;


Packages are not executable on its own. You can execute only the plan, so packages can be executed by the plan, which contains the package.


Packages provide more granularity, so that if a DB2 program is changed its package can be rebind but its plan is not required to be re bound.