PowerExchange Interfaces for PowerCenter

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

Back Next

Restart Token File

PWXPC stores the restart tokens in the state table in the target database for relational targets and in the state file on the PowerCenter Integration Service platform for nonrelational targets. The restart token file provides:

Initial restart tokens for new CDC sessions

Overrides for the restart tokens in the state table or file for existing CDC sessions

PWXPC uses the restart token file in the folder specified in the

RestartToken File Folder

attribute of the source CDC connection. PWXPC automatically creates this folder, if it does not exist, when the attribute contains the default value of $PMRootDir/Restart. PWXPC does not automatically create any other restart token folder name.

During session initialization, PWXPC:

Uses the name specified in the

RestartToken File Name

attribute to create an empty restart token file, if one does not already exist.

Creates a merged view of the restart tokens by reconciling the restart tokens specified in the restart token file with those in state tables and the state file for all relational and non-relations targets, respectively.

Places the results of the restart token reconciliation process into an initialization file in the restart token file directory and empties out the restart token file.

Emptying the restart token file ensures that it does not override the state table or state file restart tokens with the same restart information the next time the session is run.

During normal termination, PWXPC writes the ending restart tokens into a termination file in the restart token file directory. The restart token files containing the initialization and termination restart tokens have the following names:

<restart_token_file_name>yyyymmddhhmmss_init
<restart_token_file_name>yyyymmddhhmmss_term

Where:

restart_token_file_name is the restart token file name from the CDC connection

yyyymmddhhmmss is the initialization file creation time stamp

init or term is for initialization and termination files, respectively

For example, a CDC source application connection specifies a restart token file name of my.app.txt, which does not exist. PWXPC creates the following files on the PowerCenter Integration Service platform in the restart token file folder specified in the connection:

my.app.txt

my.app.txtyyyymmddhhmmss_init

my.app.txtyyyymmddhhmmss_term

The restart token file, my.app.txt, is empty. The timestamps on both the initialization and termination files are the same to indicate that they are related to the same run. The termination file may not exist or may be empty if the session fails.

If you use the default value of zero for the connection attribute

Number of Runs to Keep RestartToken File

, PWXPC keeps only one copy of the paired initialization and termination files. Otherwise, PWXPC uses the value specified in that attribute to determine the number of backup copies of these paired files to keep. During termination, PWXPC removes any additional pairs of the backup files beyond the

Number of Runs to Keep RestartToken File

value.

Understanding PWXPC Restart and Recovery

How Restart Points Are Determined

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal