PowerExchange Interfaces for PowerCenter

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

Back Next

Example: Session Recovery

In this example, a CDC session with relational targets is aborted in the Workflow Monitor. The Restart Task command is issued from the Workflow Monitor for the CDC session. PWXPC issues the following message:

PWXPC_12092 [INFO] [CDCRestart] Warm start requested. Targets will be resynchronized automatically if required

PWXPC automatically recovers when the session is warm started. PWXPC issues the following messages displaying the restart tokens found for the session and its sources:

PWXPC_12060 [INFO] [CDCRestart] 

===============================
Session restart information:
===============================
Extraction Map Name            Restart Token 1                                    Restart Token 2                    Source
d1dsn8.rrtb0004_RRTB_SRC_004   00000FCA65840000000000000D2E004A00000000FFFFFFFF   C1E4E2D3404000000D21B1A500000000   GMD storage
d1dsn8.rrtb0009_RRTB_SRC_009   00000FCA65840000000000000D2E004A00000000FFFFFFFF   C1E4E2D3404000000D21B1A500000000   GMD storage
d1dsn8.rrtb0005_RRTB_SRC_005   00000FCA65840000000000000D2E004A00000000FFFFFFFF   C1E4E2D3404000000D21B1A500000000   GMD storage
d1dsn8.rrtb0006_RRTB_SRC_006   00000FCA65840000000000000D2E004A00000000FFFFFFFF   C1E4E2D3404000000D21B1A500000000   GMD storage
d1dsn8.rrtb0008_RRTB_SRC_008   00000FCA65840000000000000D2E004A00000000FFFFFFFF   C1E4E2D3404000000D21B1A500000000   GMD storage
d1dsn8.rrtb0003_RRTB_SRC_003   00000FCA65840000000000000D2E004A00000000FFFFFFFF   C1E4E2D3404000000D21B1A500000000   GMD storage
d1dsn8.rrtb0002_RRTB_SRC_002   00000FCA65840000000000000D2E004A00000000FFFFFFFF   C1E4E2D3404000000D21B1A500000000   GMD storage
d1dsn8.rrtb0001_RRTB_SRC_001   00000FCA65840000000000000D2E004A00000000FFFFFFFF   C1E4E2D3404000000D21B1A500000000   GMD storage
d1dsn8.rrtb0007_RRTB_SRC_007   00000FCA65840000000000000D2E004A00000000FFFFFFFF   C1E4E2D3404000000D21B1A500000000   GMD storage

PWXPC issues the PWXPC_12069 message when it detects that recovery is required. The 12069 message usually includes the begin-UOW (from
) and end-UOW (to
) restart tokens for the oldest uncommitted UOW that PWXPC re-reads during recovery. PWXPC stores end-UOW restart tokens in the state table and file unless sub-packet commit is used.

PWXPC_12069 [INFO] [CDCRestart] Running in recovery mode. Reader will resend the the oldest uncommitted UOW to resync targets: 
from: Restart 1 [00000FCA65840000000000000D2E004A00000000FFFFFFFF] : Restart 2 [C1E4E2D3404000000D21B1A500000000] 
  to: Restart 1 [00000FCA65840000000000000D300D8000000000FFFFFFFF] : Restart 2 [C1E4E2D3404000000D21B1A500000000].

The from
restart tokens are the same as those displayed in the PWXPC_12060 messages for all sources. This restart token represents the start point in the change stream for the oldest uncommitted UOW. The to
restart tokens represent the end of the oldest uncommitted UOW. Since the application connection for this session specifies sub-packet commit, the Restart 2 value is the begin-UOW value in both cases. The Restart 1 values represent the start and end change records in the Restart 2 UOW.

PWXPC rereads the changes between the two restart token values in the 12069 message and issues a commit for the data and the restart tokens. The PowerCenter Integration Service writes the data to the target tables and the restart tokens to the state table.

PWXPC and the PowerCenter Integration Service continue to read and write data and restart tokens until the session ends or is stopped.

Rename Saved Search

Table of Contents

PowerExchange Interfaces for PowerCenter

PowerExchange Interfaces for PowerCenter

Example: Session Recovery

Example: Session Recovery