Saving Restart Tokens Before Upgrading PowerCenter
Saving Restart Tokens Before Upgrading PowerCenter
Use the following procedure to capture the restart point for CDC sessions before upgrading PowerCenter.
To save restart tokens before upgrading PowerCenter:
Shut down all CDC sessions cleanly.
Verify that the final restart token files for all CDC sessions are saved.
Depending on the PowerCenter release that you are migrating from, either PWXPC records the restart tokens or you recover them, as follows:
If you are migrating from a PowerCenter release earlier than 8.1.1 SP2, PWXPC writes the final restart tokens to the restart token file when the CDC session ends.
If you are migrating from PowerCenter 8.1.1 SP2 through SP5 without enhanced restart enabled, PWXPC writes the final restart tokens to the restart token file when the CDC session ends.
If you are migrating from PowerCenter 8.1.1 SP2 through SP5 with enhanced restart enabled, run recovery on all CDC sessions. PWXPC creates a backup restart token file with an appended timestamp that contains the restart tokens.
If you are migrating from PowerCenter 8.5 or later, run recovery on all CDC sessions. PWXPC updates the restart token file with the restart tokens.
As a precaution, back up any relational tables that are targets in the CDC sessions. Also, back up the PowerCenter recovery tables.
Upgrade PowerCenter.
If you did not save the final restart token files before the PowerCenter upgrade, you must manually build the restart token file by using the session log. For sessions that run on PowerCenter 8.1.1 SP2 or later with enhanced restart enabled, use the restart tokens from the NRDBCDC_RDR_12075 or PWXPC_12075 message. You can use the restart tokens from the message in conjunction with a special override statement to get the restart tokens for all sources in a CDC session. For sessions that run on PowerCenter releases earlier than 8.1.1 SP2 or without enhanced restart, use the restart tokens in the restart token files. If you need assistance, contact Informatica Global Customer Support.