Table of Contents

Search

  1. Preface
  2. Change Data Capture Introduction
  3. PowerExchange Listener
  4. PowerExchange Condense
  5. DB2 for i5/OS Change Data Capture
  6. Remote Logging of Data
  7. Introduction to Change Data Extraction
  8. Extracting Change Data
  9. Monitoring CDC Sessions
  10. Managing Change Data Extractions
  11. Tuning CDC Sessions
  12. Appendix A: DTL__CAPXTIMESTAMP Time Stamps

CDC Guide for i5/OS

CDC Guide for i5/OS

Monitoring Refresh Processing of the CDC Library Interest List

Monitoring Refresh Processing of the CDC Library Interest List

Use key messages to determine the status of refreshing the CDC library interest list for added or deleted libraries.
  • The following messages, which are written to the AS400EVENTMSGQ event message queue, indicate that a SNDPWXJRNE refresh request was successfully processed:
    DTL3003I PowerExchange has processed add event
    event_identifier
    DTL3004I PowerExchange has processed delete event
    event_identifier
    For these messages to be issued, you must have specified an
    Event Identifier
    value for the SNDPWXJRNE command.
  • The following messages, which are written to the PowerExchange message log file, provide the standard message output for a refresh request:
    PWX-06813 Rebuilding CDC library interest list after processing user journal entry with type code
    code
    for a SNDPWXJRNE request at journal time
    timestamp
    with sequence
    sequence_number
    . PWX-06814 Rebuilding CDC library interest list to
    action
    libraries PWX-06815
    library1_name use_count
    library2_name use_count
    library3_name use_count
    library4_name use_count
    . PWX-06815
    library5_name use_count
    library6_name use_count
    library7_name use_count
    library8_name use_count
    . PWX-06815 ... PWX-06781 Override for Table (
    library
    /
    file
    ) collection using registration
    registration_name
    (DB2 for i5/OS CDC) PWX-06118 Registration loaded: DBName:
    database_name
    RegName:
    name
    Creator:
    creator
    Table:
    table_name
    PWX-06816 Rebuild of CDC library interest list is complete after processing user journal entry with type code
    code
    for
    file_count
    sources
    • PWX-06813
      . Indicates the start of rebuilding the CDC library interest list for a specific SNDPWXJRNE refresh request.
    • PWX-06814
      . Indicates whether the CDC library interest list is being rebuilt for an add library or a delete library operation.
    • PWX-06815
      . Lists the added or deleted libraries for which you are refreshing the CDC library interest list. Each message lists up to four libraries. If more than four libraries were added or deleted, this message is issued for each set of four libraries in the SNDPWXJRNE refresh request, as needed.
    • PWX-06781
      . Indicates that a library name override is in effect, as required for refresh processing. The override must be an asterisk (*) wildcard and specified in the PowerCenter
      Library/File Override
      session property.
    • PWX-06816
      . Indicates the completion of rebuilding the CDC library interest list.
    The PowerExchange message log file is either the DTLLOG member of the the LOG file in the
    datalib
    library if alternate logging is not enabled, or the JOB
    nnnnnn
    file in the
    datalib
    library, where
    nnnnnn
    is the i5/OS job number for the PowerExchange Listener task, if alternate logging is enabled.

0 COMMENTS

We’d like to hear from you!