Component Processing Summary
This section provides a summary of the processing performed by the ChangeMan ZMF base product and the Db2 option for each kind of Db2 component.
Programs with Imbedded SQL
Library Types
| Component |
Lib Type or Like |
Sub Type |
| Source |
Like-S |
|
| DBRM |
Like-P |
R |
| Load |
Like-L |
|
Stage (Like-S)
Language is a high-level language such as COBOL or assembler.
Db2 Precompile is YES.
| Action |
Object |
| Copy to staging library (if not there) |
Source |
| Delete from staging library |
DBRM Load |
| Precompile (extract SQL) |
DBRM |
| Compile with high level language procedure. |
Object |
| Link edit object |
Load |
| Build relationship to source |
PM records |
| Copy to staging library |
DBRM Load |
Audit
| Action |
Object |
| Examine relationships to package components |
|
| Examine relationships to baseline components |
|
| Action |
Object |
| Copy members to promotion library |
DBRM Load |
| Determine which plans/packages to bind |
|
| Template BIND command |
BIND |
| Execute bind |
Db2 Catalog |
Install/Backout
| Action |
Object |
| Baseline ripple or copy to production library |
Source DBRM Load |
| Determine which plans/packages to bind |
|
| Template BIND command |
BIND |
| Execute bind |
Db2 Catalog |
BIND Commands
Library Types
| Component |
Lib Type or Like |
Sub Type |
| Plan BIND commands |
Like-P |
B |
| Package BIND commands |
Like-P |
P |
Stage (Like-P)
| Action |
Object |
| Copy to staging library (if not there) |
|
Audit
| Action |
Object |
| Examine relationships to baseline components |
|
| Action |
Object |
| Copy members to promotion library |
|
| Template BIND command |
BIND |
| Execute bind |
Db2 Catalog |
Install/Backout
| Action |
Object |
| Baseline ripple or copy to production library |
|
| Template BIND command |
BIND |
| Execute bind |
Db2 Catalog |
Procedure Definition DDL
Library Types
| Component |
Lib Type or Like |
Sub Type |
| Procedure Definition |
Like-P |
D |
Stage (Like-P)
| Action |
Object |
| Copy to staging library (if not there) |
Procedure Defn |
Audit
| Action |
Object |
| Examine relationships to baseline components |
|
| Action |
Object |
| Copy members to promotion library |
Procedure Defn |
| Implement Procedure Definition |
Db2 Catalog |
Install/Backout
| Action |
Object |
| Baseline ripple or copy to production library |
Procedure Defn |
| Implement Procedure Definition |
Db2 Catalog |
Stored Procedures – External
Library Types
| Component |
Lib Type or Like |
Sub Type |
| Source |
Like-S |
|
| DBRM |
Like-P |
R |
| Load |
Like-L |
S |
Stage (Like-S)
Language is a high-level language such as COBOL or assembler.
Db2 Precompile is YES.
| Action |
Object |
| Copy to staging library (if not there) |
Source |
| Delete from staging library |
DBRM Load |
| Precompile (extract SQL) |
DBRM |
| Compile with high level language procedure |
Object |
| Link edit object |
Load |
| Build relationship to source |
PM records |
| Copy to staging library |
DBRM Load |
Audit
| Action |
Object |
| Examine relationships to package components |
|
| Examine relationships to baseline components |
|
| Action |
Object |
| Copy members to promotion library |
DBRM Load |
| Determine which plans/packages to bind |
|
| Template BIND command |
BIND |
| Execute bind |
Db2 Catalog |
| VARY WLM,APPLENV=envname,REFRESH |
WLM-managed address space |
Install/Backout
| Action |
Object |
| Baseline ripple or copy to production library |
Source DBRM Load |
| Determine which plans/packages to bind |
|
| Template BIND command |
BIND |
| Execute bind |
Db2 Catalog |
| VARY WLM,APPLENV=envname,REFRESH |
WLM-managed address space |
Stored Procedures – External SQL
Library Types
| Component |
Lib Type or Like |
Sub Type |
| Source |
Like-S |
Q |
| DBRM |
Like-P |
R |
| Load |
Like-L |
S |
Stage (Like-S)
Language invokes procedure CMNSQL.
Db2 Precompile is YES.
| Action |
Object |
| Copy to staging library (if not there) |
Source |
| Delete from staging library |
DBRM Load |
| Convert to SQL source to C |
C-source |
| Precompile C (extract SQL) |
DBRM |
| Compile with C language procedure |
Object |
| Link edit object |
Load |
| Build relationship to source |
PM records |
| Copy to staging library |
DBRM Load |
Audit
| Action |
Object |
| Examine relationships to package components |
|
| Examine relationships to baseline components |
|
| Action |
Object |
| Copy members to promotion library |
Source DBRM Load |
| Determine which plans/packages to bind |
|
| Template BIND command |
BIND |
| Execute bind |
Db2 Catalog |
| Extract Procedure Definition DDL from source SQL |
Procedure Defn |
| Implement Procedure Definition |
Db2 Catalog |
| VARY WLM,APPLENV=envname,REFRESH |
WLM-managed address space |
Install/Backout
| Action |
Object |
| Baseline ripple or copy to production library |
Source DBRM Load |
| Determine which plans/packages to bind |
|
| Template BIND command |
BIND |
| Execute bind |
Db2 Catalog |
| Extract Procedure Definition DDL from source SQL |
Procedure Defn |
| Implement Procedure Definition |
Db2 Catalog |
| VARY WLM,APPLENV=envname,REFRESH |
WLM-managed address space |
Stored Procedures - Native SQL
Native SQL stored procedure deployment mechanisms:
-
Drop/Create
-
Alter Add Version
-
Bind Package Deploy
There is no build process for these components. All processing takes place at the Db2 subsystem which is the target for the promotion/install/etc. For BIND DEPLOY the relevant bind command is issued to the target Db2 subsystem but routed for execution to the source subsystem. The BIND DEPLOYs from the source to the target.
Library Types
| Component |
Lib Type or Like |
Sub Type |
| Source |
Like-P |
N |
Stage
| Action |
Object |
| Copy to staging library (if not there) |
Source |
Audit
| Action |
Object |
| Copy member to promotion library |
Source |
| Implement procedure definition (via templates if defined) |
Source, where bind deploy not in use |
| Deploy procedure definition |
Bind deploy from source Db2 catalog |
| Activate procedure version |
If Db2 versioning in use |
Install/Backout
| Action |
Object |
| Copy member to production library |
Source |
| Implement procedure definition (via templates if defined) |
Source, where bind deploy not in use |
| Deploy procedure definition |
Bind deploy from source Db2 catalog |
| Activate procedure version |
If Db2 versioning in use |
Stored Procedures – REXX
REXX stored procedures:
During the build process, all you have to do is place the source for the REXX stored procedure in the SYSEXEC concatenation of the started task associated with the target WLM-managed address space.
Library Types
| Component |
Lib Type or Like |
Sub Type |
| Source |
Like-P |
S |
Stage
| Action |
Object |
| Copy to staging library (if not there) |
Source |
Audit
| Action |
Object |
| Examine relationships to baseline components |
|
| Action |
Object |
| Copy members to promotion library |
Source |
| VARY WLM,APPLENV=envname,REFRESH |
WLM-managed address space |
Install/Backout
| Action |
Object |
| Baseline ripple or copy to production library |
Source |
| VARY WLM,APPLENV=envname,REFRESH |
WLM-managed address space |
User Defined Functions - External
Library Types
| Component |
Lib Type or Like |
Sub Type |
| Source |
Like-S |
|
| DBRM |
Like-P |
R |
| Load |
Like-L |
|
Stage (Like-S)
Language is high level language such as COBOL or assembler.
Db2 Precompile is YES.
| Action |
Object |
| Copy to staging library (if not there) |
Source |
| Delete from staging library |
DBRM Load |
| Precompile (extract SQL) |
DBRM |
| Compile |
Object |
| Link edit object |
Load |
| Build relationship to source |
PM records |
| Copy to staging library |
DBRM Load |
Audit
| Action |
Object |
| Examine relationships to package components |
|
| Examine relationships to baseline components |
|
| Action |
Object |
| Copy members to promotion library |
DBRM Load |
| Determine which plans/packages to bind |
|
| Template BIND command |
BIND |
| Execute bind |
Db2 Catalog |
Install/Backout
| Action |
Object |
| Baseline ripple or copy to production library |
Source DBRM Load |
| Determine which plans/packages to bind |
|
| Template BIND command |
BIND |
| Execute bind |
Db2 Catalog |
User Defined Functions - Source
Library Types
| Component |
Lib Type or Like |
Sub Type |
| Function Definition |
Like-P |
D |
Stage (Like-P)
| Action |
Object |
| Copy to staging library (if not there) |
Function Defn |
Audit
| Action |
Object |
| Examine relationships to baseline components |
|
| Action |
Object |
| Copy members to promotion library |
Function Defn |
| Implement Function Definition |
Db2 Catalog |
Install/Backout
| Action |
Object |
| Baseline ripple or copy to production library |
Function Defn |
| Implement Function Definition |
Db2 Catalog |
Database Triggers
Library Types
| Component |
Lib Type or Like |
Sub Type |
| Trigger Definition |
Like-P |
T |
| Stage (Like-P) |
|
|
| Action |
|
Object |
| Copy to staging library (if not there) |
Trigger Defn |
|
Audit
| Action |
Object |
| Examine relationships to baseline components |
|
| Action |
Object |
| Copy members to promotion library |
Trigger Defn |
| Implement Trigger Definition |
Db2 Catalog |
| Reorder Triggers in correct sequence |
Db2 Catalog |
Install/Backout
| Action |
Object |
| Baseline ripple or copy to production library |
Trigger Defn |
| Implement Trigger Definition |
Db2 Catalog |
| Reorder Triggers in correct sequence |
Db2 Catalog |