Table of Contents

Search

  1. Preface
  2. Part 1: PowerExchange Change Data Capture Introduction
  3. Part 2: CDC Components Configuration and Management
  4. Part 3: CDC Sources Configuration and Management
  5. Part 4: Change Data Extraction
  6. Part 5: Monitoring and Tuning
  7. Appendix A: CDC for z/OS Troubleshooting
  8. Appendix B: DTL__CAPXTIMESTAMP Time Stamps

Example DB2 ECCR Startup Report

Example DB2 ECCR Startup Report

For a DB2 for z/OS ECCR warm start, the following report shows the ECCR options that are in effect and initialization processing:
PWXEDM177401I START OF REPL2OPT CONTROL STATEMENTS DB2 PLAN=PWXC1020 RN=DSNC EC PERMIL=000 STAT LEV=ST SEC=3600 IFI306 OPT=Y PWXEDM177402I END OF REPL2OPT CONTROL STATEMENTS PWXEDM177150I Connected to DB2 subsystem DSNC PWXEDM177155I DB2 DSN6SPRM configuration parameter APPLCOMPAT is 'V12R1M500' PWXEDM177155I DB2 DSN6SPRM configuration parameter RESTRICT_ALT_COL_FOR_DCC is 'NO' PWXEDM177155I DB2 DSN6SPRM configuration parameter CATALOG is 'DSNC' PWXEDM177137I -DISPLAY GROUP DSN7100I -DSNC DSN7GCMD *** BEGIN DISPLAY OF GROUP(........) CATALOG LEVEL(V12R1M500) CURRENT FUNCTION LEVEL(V12R1M500) HIGHEST ACTIVATED FUNCTION LEVEL(V12R1M500) HIGHEST POSSIBLE FUNCTION LEVEL(V12R1M500) PROTOCOL LEVEL(2) GROUP ATTACH NAME(....) -------------------------------------------------------------------- DB2 SUB DB2 SYSTEM IRLM MEMBER ID SYS CMDPREF STATUS LVL NAME SUBSYS IRLMPROC -------- --- ---- -------- -------- ------ -------- ---- -------- ........ 0 DSNC -DSNC ACTIVE 121500 ZO61 DRLC DSNCIRLM -------------------------------------------------------------------- SPT01 INLINE LENGTH: 32138 *** END DISPLAY OF GROUP(........) DSN9022I -DSNC DSN7GCMD 'DISPLAY GROUP ' NORMAL COMPLETION PWXEDM177601I DB2 Product ID: DSN1201500 PWXEDM177601I DB2 Catalog level: V12R1M500 PWXEDM177404I START OF REPL2CTL CONTROL STATEMENTS *---+----1----+----2----+----3----+----4----+----5 CA NAME=A1020DSC *---+----1----+----2----+----3----+----4----+----5 PWXEDM177405I END OF REPL2CTL CONTROL STATEMENTS PWXEDM172852I Options in effect: Load Library containing EDMSDIR. . . . . : ABCQA.V1020.A02L.USERLIB EDMSDIR assembly date/time . . . . . . . : 20170315 22.26 EDP Rollup . . . . . . . . . . . . . . . : V1020_HF2B04_20190211 Product distribution date. . . . . . . . : 20181029 Product distribution level . . . . . . . : 2.4.05 Agent Id . . . . . . . . . . . . . . . . : A02A Logger Id. . . . . . . . . . . . . . . . : A02L SYSOUT class . . . . . . . . . . . . . . : * Action if ECCR error encountered . . . . : Continue PWXEDM172886I The following Load Module replacements have been installed: 0----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+ 4$+4444+4444$$$44$$$$$$$$$$$$$+$+$$$$+$$$$$$$$$$+$$$$$$$$$$$$$$$$$+$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ 100----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+ $$$$$$$$$$$$$$+$$$$$$$$$$$$+$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ 200----+----1----+----2----+----3----+----4----+----5- $ $+$+$$$$$$+$$$$$$$$$$$$$+$$$$$$$$$$$$$$$$$$$$$$ $$ PWXEDM172818I Joined XCF group 'A02L' as member 'A1020DSC' PWXEDM172841I EDM ECCR A1020DSC connected to EDM Logger A02L, Log RBA=X'00000052AE880000' PWXEDM172808I Change Capture active for Tag DB2DSNCalldec21 DB2 table DSNC/CWHITL1.ALL_DEC_002 PWXEDM172808I Change Capture active for Tag DB2DSNCalldte1 DB2 table DSNC/CWHITL1.ALL_DATES_001 PWXEDM172808I Change Capture active for Tag DB2DSNCalldte21 DB2 table DSNC/CWHITL1.ALL_DATES_002 PWXEDM172808I Change Capture active for Tag DB2DSNCphoto3in1 DB2 table DSNC/CWHITL2.PHOTO3 PWXEDM177413I Start processing spooled REPL2CTL statements *---+----1----+----2----+----3----+----4----+----5 CA NAME=A1020DSC *---+----1----+----2----+----3----+----4----+----5 PWXEDM177414I End processing spooled REPL2CTL statements PWXEDM177548I Verifying Capture Directory supports up to DB2 V12.1.500 catalog level. PWXEDM177552I Capture Directory supports up to DB2 V12.1.500 catalog level. PWXEDM177137I -START TRACE(MONITOR) PLAN(PWXC1020) LOCATION(A1020DSC) CLASS(1) DSNW130I -DSNC MONITOR TRACE STARTED, ASSIGNED TRACE NUMBER 04 DSN9022I -DSNC DSNWVCM1 '-START TRACE' NORMAL COMPLETION PWXEDM177283I Begin DB2 ECCR WARM start processing. PWXEDM177398E Table CWHITL1.QACLOB1 probably not defined with DATA CAPTURE CHANGES PWXEDM177340I MAINTENANCE OF CAPTURE DIRECTORY IS COMPLETE PWXEDM177310I WARM start processing is complete. PWXEDM172820I Change Capture initialized for DB2 on DSNC PWXEDM177013I LOGGER: LAST DB2 READ LOC 000000000009C075232E OLDEST OPEN UOW *NONE* PWXEDM177267I STARTING AT DB2 LOG LOCATION 000000000009C075232E

0 COMMENTS

We’d like to hear from you!