CDC Guide for Linux, UNIX, and Windows

10.5
- 10.5.6
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

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:

Stop the workflow.

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.

Make changes to the session or workflow, if necessary.

Verify that the restart token file in the source CDC connection points to the same restart token file updated in the recovery.

If you add sources to the CDC session, add statements to the restart token file that provide restart tokens for the additional sources.

If you remove sources from the CDC session, update the restart token file to remove their restart tokens.

Cold start the CDC session.

Managing Change Data Extractions

Examples of Adding Sources and Creating Restart Tokens

Download Guide

Watch

Comments

Communities

Knowledge Base