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

PowerExchange CDC Components

PowerExchange CDC Components

Multiple PowerExchange components are involved in change data capture processing.
These components are:
PowerExchange Listener
The PowerExchange Listener coordinates activities across systems, initiates requests, or processes requests from third-party applications. You must run a PowerExchange Listener to move data across systems.
The PowerExchange Listener performs the following functions:
  • Handles all tasks that use capture registrations and extraction maps.
  • Communicates with the PowerExchange Navigator interface.
  • Communicates with the PowerExchange Client for PowerCenter (PWXPC) to integrate with PowerCenter.
  • Run processes to extract data for client requests.
PowerExchange Condense
PowerExchange Condense captures change data and stores the data in condense files. The condense files store only the successfully completed UOWs, in chronological order by end time. When an extraction session runs, the data is extracted from the condense files rather than from the change stream.
If you add or edit capture registrations, you must restart the PowerExchange Condense job to activate the additional or changed registrations.
PowerExchange Navigator
The PowerExchange Navigator is a Windows graphical user interface from which you create and maintain capture registrations and extraction maps. You can also define data maps if you need to do column-level processing, such as building expressions to populate user-defined columns.
Create a capture registration for each source table of interest for CDC. The PowerExchange Navigator automatically generates a corresponding extraction map.
A capture registration identifies:
  • The data source type, which is AS4 for DB2 for
    i5/OS
  • The columns in a source table for which to capture changes
  • Whether to use PowerExchange Condense full or partial processing of change data
  • Whether the registration is active for use in CDC

0 COMMENTS

We’d like to hear from you!