Skip to content


Active Libraries : An Active library, as used in this document, is a promotion, production, or baseline library that contains Db2 components. The library can contain Db2 program load modules, BIND commands, or stored procedures. When a change to an active library is detected, either BIND processing or stored procedure processing is included in the promotion or installation process JCL.

DBRM : DBRM is a Db2 Data Base Request Module. A DBRM is the output of the Db2 precompiler after it has processed a source module containing SQL statements.

Rebind : This manual frequently refers to the process of rebinding plans. In fact, plans processed by ChangeMan are actually not rebound, but bound with the REPLACE option. In Db2, the REBIND command does not use information external to the catalog, such as a DBRM in a PDS. Instead, the REBIND command used the SYSIBM.SYSDBRM and SYSIBM.SYSPLAN tables.
BIND with the REPLACE option, however, uses information in DBRM PDSs to replace a plan in the catalog. Since ChangeMan is processing change SRC components, there is a high probability that the related DBRMs have new time stamps, and need to be updated in Db2 plans.

SPUFI : SPUFI is an acronym for SQL Processor Using File Input. SPUFI can be used to directly enter SQL statements without having to write a program to process those statements.

SQL : SQL is Structured Query Language, the data manipulation language for Db2.

Versioning : Versioning in Db2 is the ability to run multiple versions of a program. Multiple versions of a program can exist with the same Collection Id and NAME combination. The sequence of concatenation of load libraries determines which program executes and Db2 will find a matching package ready for execution amongst the many that are available.