DB2 ECCR Configuration Statements in the REPL2OPT DD Data Set
DB2 ECCR Configuration Statements in the REPL2OPT DD Data Set
PowerExchange 10.1 introduces the following changes to configuration statements in the data set or RUNLIB member that is allocated by the REPL2OPT DD statement in the DB2 ECCR JCL:
IFI306 [OPT={
N
|Y|F}
Changed
. The OPT keyword has a new valid value of F. Set OPT=F to use DB2 object filtering to reduce the volume of change records that DB2 passes to the ECCR. DB2 object filtering is supported in DB2 Version 11 and in DB2 Version 10 with IBM APAR PM90568. The DB2 IFI 306 READS routine uses a list of table spaces to deliver only the change data for the tables in those table spaces. If the list of tracked table spaces changes, the ECCR initiates REFRESH processing to use the updated list. With the setting of F, the ECCR cannot capture inserts for DB2 QUIESCE operations from the DB2 catalog table SYSCOPY. The default value for OPT is still N.
SKIPURDML
eccr_description_of_urid
Optional. Causes the ECCR to skip operations in a specific DB2 unit of recovery (UR). Use this statement to have the ECCR skip change records from a problematic area of the log. The
urid
value is the ECCR description of the DB2 URID, which consists of 20 hexadecimal characters, a period, and four ending hexadecimal characters. For example:
SKIPURDML 000000000004AB60DEC0.0000
Use this statement only at the direction of Informatica Global Customer Support.
You can specify up to 255 SKIPURDML statements in the REPL2OPT DD data set.
If you specify this parameter, the ECCR issues messages PWXEDM177230I and PWXEDM!77231W to describe the UR and each log record that is skipped.
For more information, see the "DB2 for z/OS Change Data Capture" chapter in the
PowerExchange CDC Guide for z/OS
.
These statements and parameters are also available in 9.6.1 HotFix 4. They are not available in 10.0.