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

Configuration Tasks for Remote Logging

Configuration Tasks for Remote Logging

To log change data to remote PowerExchange Logger for Linux, UNIX, and Windows log files and have PowerCenter CDC sessions extract data from those log files, complete the following configuration tasks:
  1. Install PowerExchange on the system where the PowerExchange Logger log files will be located.
  2. Customize the pwxccl.cfg configuration file on the system with the PowerExchange Logger log files.
  3. Customize the dbmover configuration file on the system with the PowerExchange Logger log files.
    Copy the source-specific CAPI_CONNECTION statements from the source system to the dbmover file on the system with the PowerExchange Logger log files.
    Each PowerExchange Logger must have a unique pwxccl.cfg configuration file and a unique dbmover configuration file.
  4. Configure a dbmover configuration file for the PowerExchange Listener on the system with the PowerExchange Logger log files.
    You can use the same dbmover file for the PowerExchange Logger and the PowerExchange Listener. If you use different dbmover files, both files must specify the same CAPT_PATH value.
    If the PowerExchange Logger log files are on the PowerCenter Integration Service machine, you can use a local connection instead of the PowerExchange Listener for change data extractions.
  5. If you are not using a "local" connection, start the PowerExchange Listener on the system with the PowerExchange Logger log files.
  6. Start the PowerExchange Logger on the system with the PowerExchange Logger log files.
  7. Customize the dbmover configuration file on the PowerCenter Integration Service machine.
  8. Configure capture registrations for PowerExchange Logger use.
  9. Configure PWX CDC Real Time connection attributes for the CDC session to extract change data from the PowerExchange Logger log files.

0 COMMENTS

We’d like to hear from you!