Skip to content

Overview

If you are installing ChangeMan ZMF for the first time, you can defer configuring the Db2 Option until later, after your DBA and application developers have agreed on how they want to manage Db2 components with ChangeMan ZMF. The configuration described in this chapter does not play any part in the processing of non-Db2 components through the ChangeMan ZMF package life cycle.

The following table appears throughout this book to tell you how to define Db2 objects and application components that use Db2. The table also shows you how the definitions relate to other definitions.

Db2 Component Like Target Type Sel Opt Sub Typ BIND/SQL/SERVICE
Db2 Application Program Source S Db2 Program Load
Db2 Application Program Load L B
DBRM P D R B
BIND PLAN Command P D B B
BIND PACKAGE Command P D P B
External Stored Procedure Source S Stored Procedure Load
External SQL Stored Procedure Source S Stored Procedure Load D Q S
External Stored Procedure Load L D S B & S
Native SQL Stored Procedure P D N S
General DDL (e.g. CREATE PROCEDURE for external SP) P D D S
User Defined Function Definition P D D S
Trigger Definition P D T S
BIND Service command P D V V
Service GRANT command P D V V

* Db2 Active Library specification for BIND plan/pkg (B), Process SQL (S), and Bind Service (V).

Note

  • Load libraries containing external stored procedures must be PDSE. This includes staging, promotion, baseline, and production libraries. If stored procedure load libraries are defined as PDS, a link edit for stage, recompile, or relink of the stored procedure may fail with message IEW2606S.

  • The execution load library containing stored procedures (baseline or production) must be concatenated in the STEPLIB of the appropriate Workload Manager (WLM) managed address space.

  • Bind service commands and the related grant components can be either PDSE or zFS based.