DB2- Bind Package and Bind Plan

Bind Package:

A package is a single, bound DBRM with optimized access paths. By using packages, the table access logic is “packaged” at a lower level of granularity than a plan.

Plan==> Package

As we all know “Bind Package” is not executable.  Exceptions: UDFs and Triggers

Bind Plan:

A plan is an executable module containing the access path logic produced by the DB2 optimizer. It can be composed of one or more DBRMs and packages.

A plan can consist of one or more DBRMs, one or more packages or, a combination of packages and DBRMs.

Advertisements

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.