A package is a single-bound Database Request Module (DBRM) created using the BIND PACKAGE command. A DBRM consists of SQL statements that are separated from an application program by the precompiler.
Among the many benefits of using packages is the reduction of bind time. When a plan references packages, binding can be done at the package level, rather than at the plan level. Using a version identifier for packages is another important benefit. You can have multiple versions of the same DBRM name on a single DB2 subsystem. This functionality provides improved recovery and fallback, and the ability to store test and production data on the same DB2 subsystem. When you select packages from the Investigator, CA Chorus displays your DB2 application plans.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|