DB2 Version10: Packages Lead PLAN

A package contains bound DBRM with optimised access paths. A package can be executed by Plan. It also has Location, Collection, and package ids.

A package has 4 benefits:

  1. It reduces time means we need to rebound only that particular program.
  2. A packgae can have DBRMs of different types( for example CS bound RR-Bound etc)
  3. Packages can be versioned
  4. It is highly useful for mirror tables.
Advertisements