Table of Contents

Search

  1. Preface
  2. Part 1: PowerExchange CDC Introduction
  3. Part 2: PowerExchange CDC Components
  4. Part 3: PowerExchange CDC Data Sources
  5. Part 4: Change Data Extraction
  6. Part 5: Monitoring and Tuning
  7. Appendix A: DTL__CAPXTIMESTAMP Time Stamps

CDC Guide for Linux, UNIX, and Windows

CDC Guide for Linux, UNIX, and Windows

Configuring PowerExchange CDC with the PowerExchange Logger

Configuring PowerExchange CDC with the PowerExchange Logger

If you plan to use the PowerExchange Logger for Linux, UNIX, and Windows and run extractions in batch or continuous extraction mode, complete the following tasks to configure PowerExchange CDC:
  1. Create the PowerExchange capture catalog table.
  2. Run the DTLUCUDB SNAPSHOT command to initialize the capture catalog table.
  3. When you configure the dbmover.cfg file, include the following statements:
    • CAPT_PATH
    • CAPT_XTRA
    • UDB CAPI_CONNECTION
    • CAPX CAPI_CONNECTION (for continuous extraction mode only)
  4. Configure the pwxccl.cfg file for the PowerExchange Logger.
  5. In the PowerExchange Navigator, create a capture registration for each DB2 source table. You must select
    Part
    in the
    Condense
    drop-down list. The PowerExchange Navigator generates a corresponding extraction map.
    If capture registrations already exist for these tables, delete the existing registrations and extraction maps and create new ones.
  6. Activate the capture registrations. Usually, you do this task after materializing the targets.
  7. Start the PowerExchange Logger.
Next Step:
Configure and start extractions. You can use either batch extraction mode or continuous extraction mode.

0 COMMENTS

We’d like to hear from you!