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

Event Table Processing

Event Table Processing

Use event table processing to stop the extraction of changes based on user-defined events, such as an end-of-day event.
For example, to stop an extraction process every night, after all changes for the day are processed, write a change to the event table at midnight. This change triggers PowerExchange to stop reading change data and shut down the extraction process after the current UOW completes.
Use the following rules and guidelines:
  • You can use event table processing only with real-time or continuous extraction modes.
  • You must create the event table and define the applications that can update the table.
  • You must register the event table for change data capture from the PowerExchange Navigator.
  • A CDC session monitors a single event table. Each user-defined event requires its own event table and a separate extraction process.
  • The event table and all of the source tables in the CDC session must be of the same source type.

0 COMMENTS

We’d like to hear from you!