Table of Contents

Search

  1. Preface
  2. Summary of PowerExchange New Features and Changes
  3. PowerExchange Installation and Upgrade
  4. PowerExchange Agent
  5. PowerExchange Client for PowerCenter
  6. PowerExchange Condense
  7. PowerExchange Listener
  8. PowerExchange Logger for Linux, UNIX, and Windows
  9. PowerExchange Navigator
  10. PowerExchange Monitoring and Tuning
  11. PowerExchange Utilities
  12. PowerExchange for Adabas
  13. PowerExchange for CA Datacom
  14. PowerExchange for DB2 for i
  15. PowerExchange for DB2 for Linux, UNIX, and Windows
  16. PowerExchange for DB2 for z/OS
  17. PowerExchange for CA IDMS
  18. PowerExchange for IMS
  19. PowerExchange for Microsoft SQL Server
  20. PowerExchange for MySQL
  21. PowerExchange for Oracle
  22. PowerExchange for PostgreSQL
  23. PowerExchange for VSAM and Flat Files
  24. PowerExchange ODBC

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.

0 COMMENTS

We’d like to hear from you!