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:
Gracefully stop the workflow.
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.
Change the session or workflow as desired.
Ensure that the restart token file in the source CDC connection points to the same restart token file updated in the recovery session.
Optionally, add statements providing restart tokens to the restart token file for any new sources.
If you remove any sources from the session, update the restart token file to remove their restart tokens.