CDC Guide for z/OS

10.5.1
- 10.5.8
- 10.5.6
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

Configuring the DB2 ECCR JCL

The following sample JCL for the DB2 ECCR PROC is provided in the ECCRDB2 member of the RUNLIB library:

//<db2pref>DB2EC PROC HLQEDM=<libname_edmparm>,
//    HLQRO=<libnameloadlib>,
//    LOGGER=<zlogger>,
//    SUFFIX=<plm_symbolic_suffix>,
//    RUNLIB=<runlib>,
//    DB2EXIT=<db2exit>,
//    DB2LOAD=<db2load>
//*
//*   PROC OR JOB
//*-------------------------------------------------------------------*
//* DB2 CHANGE CAPTURE (ECCR) JCL
//*-------------------------------------------------------------------*
//* NOTE: THIS PROCEDURE CAN BE RUN AS A Z/OS STARTED TASK OR AS A JOB
//*-------------------------------------------------------------------*
//* REPLACE THE FOLLOWING ITEMS WITH PROPER INSTALLATION VALUES
//* 1. JCL DATA SET NAMES
//* 2. REPDB2CT MEMBER OF YOUR RUNLIB
//* 3. REPDB2OP MEMBER OF YOUR RUNLIB
//*-------------------------------------------------------------------*
//ECCR   EXEC PGM=PX029200,TIME=NOLIMIT
//STEPLIB  DD DISP=SHR,DSN=&HLQRO..LOADLIB
//         DD DISP=SHR,DSN=&HLQRO..LOAD
//         DD DISP=SHR,DSN=&DB2EXIT
//         DD DISP=SHR,DSN=&DB2LOAD
//EDMPARMS DD DISP=SHR,DSN=&HLQEDM..&LOGGER&SUFFIX..USERLIB
//REPL2CTL DD DISP=SHR,DSN=&RUNLIB(REPDB2CT)
//REPL2OPT DD DISP=SHR,DSN=&RUNLIB(REPDB2OP)
//EDMMSG   DD SYSOUT=*
//REPL2TRA DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//ABNLIGNR DD DUMMY                          << Ignore Abend-Aid
//IDIOFF   DD DUMMY                          <<Ignore FAULT ANALYIZER
//*
//*-------------------------------------------------------------------*
//*
//* EDMTRACE DD  SYSOUT=*     EDM Tracing
//*

In this sample, the values in pointed brackets <> are variables. During installation, these variables are replaced by specific values that you enter in the z/OS Installation Assistant.

The following table describes the JCL statements for the DB2 ECCR procedure:

JCL Statement	Description
EXEC	Specify the PX029200 program.
STEPLIB DDs	Include the PowerExchange load libraries (LOADLIB and LOAD), the DB2 load library (&DB2LOAD), and the DB2 exit load library (&DB2EXIT). If your DB2 subsystem uses EDITPROC or FIELDPROC exit routines, also include the library that contains them. All libraries in this STEPLIB concatenation must be APF-authorized. If any of the libraries are included in your system's LNKLST concatenation, you do not need to include them in the STEPLIB.
EDMPARMS DD	Specify the name of the PowerExchange USERLIB library that contains the EDMSDIR modules options module that is associated with the PowerExchange Logger for z/OS instance. If you do not include an EDMPARMS DD statement, or if the library you specify does not contain the EDMSDIR options module, the DB2 ECCR searches the STEPLIB concatenation for those options.
REPL2CTL DD	Specify the REPL2CTL file (REPDB2CT in RUNLIB) that is associated with the ECCR.
REPL2OPT DD	Specify the REPL2OPT file (REPDB2OP in RUNLIB) that is associated with the ECCR.
EDMMSG DD	Specify the output data set for PWXEDM messages from the PowerExchange ECCRs, PowerExchange Logger for z/OS, Log Read API (LRAPI), and the Log Write API (LWAPI). This data set must be a SYSOUT data set. If you do not include this DD statement, the EDMMSG data set is dynamically allocated.
REPL2TRA DD	Specify the output data set for the DB2 ECCR TRACE output. The default and recommended specification is SYSOUT=*. The DB2 ECCR writes data to this DD in error situations and if the TRACE statement is included in the REPL2OPT file.
SYSUDUMP DD	Specify the data set for storage dump data that is generated for an abend of a job step. Enter SYSOUT=* to direct output to a standard SYSOUT data set.
ABNLIGNR DD	Do not delete or comment out this DD statement. If you have the Compuware Abend-AID tool, this statement causes PowerExchange to bypass Abend-AID and use an IBM SYSUDUMP instead to collect diagnostic information after a DB2 ECCR abend. PowerExchange requires an IBM SYSUDUMP to find the last processed LSRN value to use for a subsequent ECCR special start.
IDIOFF DD	Do not delete or comment out this DD statement. If you have IBM Fault Analyzer, this statement causes PowerExchange to bypass the Fault Analyzer tool and use an IBM SYSUDUMP instead to collect diagnostic information after a DB2 for z/OS ECCR abend. PowerExchange requires an IBM SYSUDUMP to find the last processed LSRN value to use for a subsequent ECCR special start.
EDMTRACE DD	Specify the output data set for the PowerExchange common services trace. Include this DD statement only at the direction of Informatica Global Customer Support.