Table of Contents

Search

  1. Introduction
  2. PowerExchange Client for PowerCenter (PWXPC)
  3. PowerExchange ODBC
  4. PowerExchange Interfaces for PowerCenter Tips
  5. Datatypes and Code Pages
  6. PowerExchange Interfaces for PowerCenter Troubleshooting

PowerExchange Interfaces for PowerCenter

PowerExchange Interfaces for PowerCenter

Recovery Processing

Recovery Processing

Recover workflows and tasks by selecting the recover command in Workflow Manager, Workflow Monitor, or
pmcmd
. When you request recovery, PWXPC writes the following message to the session log:
PWXPC_12093 [INFO] [CDCRestart] Recovery run requested. Targets will be resynchronized if required and processing will terminate
Select Recover to populate the restart token file with the restart tokens for all sources in the CDC session so that you can cold start. You can also use recovery to ensure the targets and restart tokens are in a consistent state.
PWXPC automatically performs recovery when you warm start a workflow or task. You do not need to recover workflows and tasks before you restart them. PWXPC performs the following tasks for recovery:
  1. Reads the restart tokens from the recovery state tables and file.
  2. Creates the initialization restart token file with the reconciled restart tokens.
  3. For heterogeneous targets, PWXPC queries the PowerCenter Integration Service about the commit levels of all targets. If all targets in the session are at the same commit level, PWXPC skips recovery processing.
  4. If recovery is required for heterogeneous targets, PWXPC re-reads the data for the last UOW committed to higher-level targets and flushes it to those targets with the lower commit level. The PowerCenter Integration Service commits any flushed data and restart tokens to any relational targets and updates any nonrelational files.
    PWXPC does not read the restart token file if recovery is required.
  5. Updates the restart token file with the final restart tokens, creates the termination restart token file, and ends.
You can now warm start or cold start the workflow or task to process change data from the point of interruption.

0 COMMENTS

We’d like to hear from you!