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

Changing PowerCenter CDC Sessions

Changing PowerCenter CDC Sessions

Use this procedure to change CDC sessions. You might need to add or remove sources and targets.
After you change a CDC session, you must cold start it. Because a cold start is required, you must also get the latest restart tokens for the original sources before restarting the session. To do so, you can perform a recovery.
To change a CDC session:
  1. Stop the workflow.
  2. After the workflow ends, recover the CDC session.
    When you recover tasks, PWXPC writes the ending restart tokens for all sources in a CDC session to the restart token file that you specified on the PWX CDC application connection.
  3. Make changes to the session or workflow, if necessary.
  4. Verify that the restart token file in the source CDC connection points to the same restart token file updated in the recovery.
  5. If you add sources to the CDC session, add statements to the restart token file that provide restart tokens for the additional sources.
  6. If you remove sources from the CDC session, update the restart token file to remove their restart tokens.
  7. Cold start the CDC session.

0 COMMENTS

We’d like to hear from you!