Skip to content

CMNIALD0 - Impact Analysis Db2 Load from LDS/dataspace

Do not confuse this process with using Db2 as the primary host for I/A data. The process described here allows customers who are using the default dataspace/LDS mechanism for hosting I/A data to export that data to Db2 tables. These tables are not the same as those used to directly host I/A data.

Program CMNIALD0 extracts baseline unique number (BUN) data and component relationship data from the impact analysis LDS. The program formats that data in records ready to load to Db2 tables CMNBUN and CMNBASE.

Execution JCL for program CMNIALD0 is delivered in sample JCL member LDS2DB2 in the CNMZMF CNTL library. This member also includes a Db2 load step for tables CMNBUN and CMNBASE.

The JCL also includes Db2 DDL for an expanded CMNBASE Db2 table with impact analysis relationship data that was added with ChangeMan ZMF 6.1. The extract files created by program CMNIALD0 contain data to populate the new fields.

CMNIALD0 Input

  • BUN information extracted from the impact analysis LDS by program CMNIALU0 in the impact analysis unload process

  • Relationship information extracted from the impact analysis LDS by program CMNIALU0 in the impact analysis unload process

  • Other impact analysis information read from the IALDS impact analysis LDS

Output

  • Sequential file of data ready for load to the CMNBUN Db2 table

  • Sequential file of data ready for load to the CMNBASE Db2 table or to the extended CMNBASE table.

Sample JCL

Sample JCL to execute program CMNIALD0 is delivered in member LDS2DB2 in the CMNZMF CNTL library. The sample JCL also includes:

  • Job step to execute Db2 procedure DSNUPROC to load Db2 tables CMNBUN and CMNBASE

  • Sample LOAD statements for an extended CMNBASE table

  • Sample DDL to create the extended CMNBASE table and indexes.

DD Statements

This table describes DD statements for program CMNIALD0.

DDNAME I/O Purpose
CMNIMPCT Input Impact analysis LDS
BUNSPACE Input BUNSPACE sequential file written by program CMNIALU0 in sample JCL member LDSUNLD
RELSPACE Input The RELSPACE sequential file written by program CMNIALU0 in sample JCL member LDSUNLD
BUNDB2 Output Reformatted BUN records
RELDB2 Output Reformatted relationship records
CMNPRINT Output Report of records read and records reformatted and written. See Reporting.

...

Caution

Use the BUNSPACE and RELSPACE files created by program CMNIALU0 in sample JCL member LDSUNLD. Do not use files created by program CMNIA000 that is executed in the online impact analysis data extract (skeleton CMN$$IAX) or in sample JCL member IMPACT.

PARM Options

There are no program execution parameters for program CMNIALD0, so there is no PARM parameter in the EXEC statement.

Return Codes and Error Messages

Error messages are written to DD statement CMNPRINT.

Reporting

This is a sample report from program CMNIALD0.

20150225 13474033 ChangeMan(R) ZMF      CMNIALD0 - 8.1.0 Impact Analysis Reformat for DB2
20150225 13474033 Phase I begins
20150225 13474035               55 BUN records read
20150225 13474035               55 BUN records reformatted, written
20150225 13474035 Phase I ends
20150225 13474040 Phase II begins
20150225 13474058               96 relation records read
20150225 13474058               96 relation records reformatted, written
20150225 13474058 Phase II ends

...

Notes or Comments

  • Read the comments in sample JCL member LDS2DB2 in the CMNZMF CNTL library.

  • For input to program CMNIALD0, use the BUNSPACE and RELSPACE files created by program CMNIALU0 in sample JCL member LDSUNLD. Do not use files created by program CMNIA000 that is executed in the online impact analysis data extract (skeleton CMN$$IAX) or in sample JCL member IMPACT.

  • The impact analysis LDS is not accessed through the started task, so the started task can be up or down.

  • In job step LDS2DB2 in sample JCL member LDS2DB2:

    • The STEPLIB concatenation (or the JOBLIB concatenation if you do not use STEPLIB) must be authorized or the Db2 load step will fail.

    • You might need to add SYSUT1 and SORTWKnn data sets. Check your DSNUPROC cataloged procedure.

DDL for CMNBUN and CMNBASE

This is the DDL for Db2 tables CMNBUN and CMNBASE. (DDL for the extended CMNBASE table is included in sample JCL member LDS2DB2.)

CREATE TABLE CMNx.CMNBUN
    (INT_BUN INTEGER NOT NULL WITH DEFAULT,
    TXT_APPL CHAR(4) NOT NULL WITH DEFAULT,
    TXT_LIBTYPE CHAR(3) NOT NULL WITH DEFAULT,
    TXT_LIKE CHAR(3) NOT NULL WITH DEFAULT,
    TXT_LIKI CHAR(1) NOT NULL WITH DEFAULT,
    TXT_DSNAME CHAR(44) NOT NULL WITH DEFAULT)
    IN database.cmnspace2;
 COMMIT WORK;
CREATE TABLE CMNx.CMNBASE
    (COMPNAME CHAR(32) NOT NULL WITH DEFAULT,
    COMPTYPE INTEGER NOT NULL WITH DEFAULT,
    RELATION CHAR(3) NOT NULL WITH DEFAULT,
    TOWHAT CHAR(44) NOT NULL WITH DEFAULT,
    TOWHATYP INTEGER NOT NULL WITH DEFAULT)
 IN database.cmnspace1;
COMMIT WORK;

...