DB2 Understand the Real Use of Package

What are package and plan in DB2? A package contains bound DBRMs with optimized access paths. A package can be executed by Plan – It also has Location, Collection, and package ids.

Benefits of Package in DB2

  1. It reduces time – we need to rebound only that particular program.
  2. A package 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.