DB2 V10: Optimized Package Concept

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.

Related Posts

Author: Srini

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