Table of Contents

Search

  1. Preface
  2. PowerExchange Installation and Upgrade Overview
  3. Installation Planning
  4. Upgrade Planning
  5. Installing and Upgrading PowerExchange on IBM i
  6. Installing and Upgrading PowerExchange on Linux and UNIX
  7. Installing and Upgrading PowerExchange on Windows
  8. Installing and Upgrading PowerExchange on z/OS
  9. Appendix A: Upgrade Considerations
  10. Appendix B: PowerExchange Environment
  11. Appendix C: Manual Installation on IBM i

Installation and Upgrade Guide

Installation and Upgrade Guide

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:
  1. Shut down all CDC sessions cleanly.
  2. 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.
  3. As a precaution, back up any relational tables that are targets in the CDC sessions. Also, back up the PowerCenter recovery tables.
  4. 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.

0 COMMENTS

We’d like to hear from you!