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 without the PowerExchange Logger

Configuring PowerExchange CDC without the PowerExchange Logger

If you plan to run extractions in real-time extraction mode and
not
use the PowerExchange Logger for Linux, UNIX, and Windows, 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
  4. In the PowerExchange Navigator, create a capture registration for each source table. The PowerExchange Navigator generates a corresponding extraction map. Optionally, create a data map if you want to perform field-level processing.
    Set the
    Condense
    option to
    Part
    even though you do not plan to use the PowerExchange Logger, unless you have a specific reason not to do so. This practice prevents having to edit the capture registrations later if you decide to use the PowerExchange Logger. You might want to set the
    Condense
    option to
    None
    if you plan to run both real-time and continuous extractions against tables defined by the same capture registrations and you do not want the PowerExchange Logger to capture change data for some registered tables.
    If capture registrations already exist for the source tables, delete the existing registrations and extraction maps and create new ones.
  5. Activate the capture registrations. Usually, you do this task after materializing the targets.
Next Step:
Configure and start extractions. You must use real-time extraction mode.

0 COMMENTS

We’d like to hear from you!