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