DB2 ECCR Control Statements in the REPL2CTL DD Data Set
DB2 ECCR Control Statements in the REPL2CTL DD Data Set
To specify the DB2 for z/OS ECCR name, enter the CA NAME statement in the data set or RUNLIB member that is allocated by the REPL2CTL DD statement in the ECCR JCL. You can include the optional STOPAFT statement to indicate when to stop the ECCR.
At the completion of z/OS installation, PowerExchange creates the RUNLIB(REPDB2CT) member that contains the ECCR control statements. The REPL2CTL DD in the ECCR JCL points to this REPDB2CT member. You can edit the control statements in the REPDB2CT member, or you can copy the member under another name and then update the JCL to point to the new member name.
Syntax:
CA NAME=
eccr_name
[STOPAFT {LOGLOC=
rba
|LOGTS=
timestamp
}]
[UOWPREFIX=
xx
]
For example, the following control statement specifies PWXDB201 as the DB2 ECCR name:
CA NAME=PWXDB201
Statement descriptions:
CA NAME=
eccr_name
Required. A name for the DB2 ECCR. This name must be unique within a sysplex.
If you change the CA NAME value, the ECCR cannot warm start from the position where it last stopped.
The DB2 ECCR uses this name for the following purposes:
The ECCR name that connects to the PowerExchange Logger for z/OS to write change data
The member name that joins the XCF group of the PowerExchange Logger
The minor name of the DB2CAPT ENQ
During initialization, the DB2 ECCR issues the DB2CAPT ENQ as an exclusive ENQ with SCOPE=SYSTEMS.
As part of the ECCR-UOW field in the control information for each change record written to PowerExchange Logger log files
This name must be 1 to 8 alphanumeric characters in length. Default is PWXDB201. You can enter another name in the
z/OS
Installation Assistant during PowerExchange installation.
Informatica recommends that you use the same value for the CA NAME parameter and the DB2 ECCR started task or job name. This practice allows you to easily identify the DB2 ECCR when reviewing messages and data from the PowerExchange Logger for z/OS.
STOPAFT {LOGLOC=
rba
|LOGTS=
timestamp
}
Optional. An RBA or timestamp that determines when the DB2 ECCR will stop. The ECCR uses this parameter regardless of how you started it.
You can specify only one STOPAFT statement. In the statement, you must specify one of the following parameters:
LOGLOC=
rba
A 20-digit hexadecimal RBA value that indicates where the DB2 ECCR will stop in the DB2 log. If the ECCR is connected to a DB2 data-sharing group member, this value is a log record sequence number (LRSN).
This RBA or LRSN value must be larger than the RBA or LRSN value at which the ECCR started. Otherwise, the ECCR stops as soon as it gets the first record from the DB2 log.
LOGTS=
timestamp
A date and time that determines where the DB2 ECCR will stop in the DB2 log. When the ECCR encounters a log record that has a timestamp equal to or later than the LOGTS timestamp, the ECCR stops.
The
timestamp
value has format YYYY-MM-DD-hh.mm.ss.nnnnnn. The date must be a valid date. For example, 2012-02-31-17.15.59.000000 is not valid because February 31st is not a valid date.
Depending on how you start the ECCR, use the following criteria to set this parameter:
For a warm start, enter a timestamp value that is equal to or later than the timestamp of the last log record processed.
For a special start, enter a log record timestamp that is equal to or later than the timestamp of the log record that is specified in the STARTLOC keyword of the START statement.
For a cold start, enter a timestamp value that is equal to or later than the current time.
If STOPAFT statement is not specified, the ECCR runs until you explicitly stop it.
UOWPREFIX=
xx
A two-character prefix that is used as the first 2 bytes of the UOW ID that the DB2 ECCR creates and sends to the PowerExchange Logger for z/OS when a DB2 unit-of-recovery contains data to be captured. By default, the last two characters of the CA NAME value are used. If you use multiple DB2 ECCRs with CA NAME values that end with the same last two characters, you can use this parameter to define a unique prefix for each ECCR to include in its UOW IDs.