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

Configuring PowerExchange CDC without PowerExchange Condense

Configuring PowerExchange CDC without PowerExchange Condense

If you do not plan to use PowerExchange Condense, use this procedure to configure PowerExchange CDC.
  1. Configure the DBMOVER configuration file.
    Include the following statements:
    • CPX_DIR
    • AS4J CAPI_CONNECTION
    • UOWC CAPI_CONNECTION
    Optionally, specify the AS400EVENTMSGQ and AS400USRJRNCODE statements.
    For more information about these DBMOVER statements, see Summary of DBMOVER Parameters for CDC.
  2. In the PowerExchange Navigator, create a capture registration for each source table.
    In the
    Condense
    list, select
    Part
    or
    Full
    , unless you have a specific reason not to do so. This practice prevents having to change the capture registrations later if you decide to use PowerExchange Condense. For more information about creating capture registrations, see the
    PowerExchange Navigator User Guide
    .
    The PowerExchange Navigator generates a corresponding extraction map. Optionally, you can also create a data map if you want to perform field-level processing.
  3. For each capture registration, set the
    Status
    field to
    Active
    .
    Usually, this step is done after materializing the targets.
Next, configure extraction sessions to run in real-time extraction mode.

0 COMMENTS

We’d like to hear from you!