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

Session Log Messages

Session Log Messages

You can use messages that PWXPC and PowerCenter write to the session log to monitor the progress of CDC sessions.
When PWXPC flushes change data, PWXPC writes one of the following messages in the session log to indicate the reason for the flush:
PWXPC_10081 [INFO] [CDCDispatcher] raising real-time flush with restart tokens [
restart1
], [
restart2
] because the UOW Count [
count
] is reached
PWXPC_10082 [INFO] [CDCDispatcher] raising real-time flush with restart tokens [
restart1
], [
restart2
] because Real-time Flush Latency [
latency
] is reached
PWXPC_12128 [INFO] [CDCDispatcher] raising real-time flush with restart tokens [
restart1
], [
restart2
] because the Maximum Rows Per commit [
count
] is reached
You can use the restart tokens in these PWXPC flush messages to monitor the processing of the change data.
For each PWXPC flush message, PowerCenter writes a WRT_8160 message after committing change data to the targets. This message displays the source-based commit statistics.

0 COMMENTS

We’d like to hear from you!