Table of Contents

Search

  1. Preface
  2. Part 1: Introduction
  3. Part 2: PowerExchange Client for PowerCenter (PWXPC)
  4. Part 3: PowerExchange ODBC
  5. Appendix A: PowerExchange Interfaces for PowerCenter Tips
  6. Appendix B: Datatypes and Code Pages
  7. Appendix C: PowerExchange Interfaces for PowerCenter Troubleshooting

PowerExchange Interfaces for PowerCenter

PowerExchange Interfaces for PowerCenter

Changing CDC Sessions and Restarting from the Point of Interruption

Changing CDC Sessions and Restarting from the Point of Interruption

You can add new sources and targets to an existing CDC sessions. However, you must cold start the session after you do this, which means you need to ensure you have the proper restart information for the original sources in the session.
To change a CDC session and restart it from the point of interruption:
  1. Gracefully stop the workflow.
  2. After the workflow stops successfully, issue the Recover command for the CDC session.
    When you recover tasks, PWXPC writes the ending restart tokens for all sources in the session into the restart token file specified on the CDC connection.
  3. Change the session or workflow as desired.
  4. Ensure that the restart token file in the source CDC connection points to the same restart token file updated in the recovery session.
  5. Optionally, add statements providing restart tokens to the restart token file for any new sources.
  6. If you remove any sources from the 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!