Table of Contents

Search

  1. Preface
  2. Part 1: Introduction
  3. Part 2: PowerExchange Client for PowerCenter (PWXPC)
  4. Part 3: PowerExchange ODBC
  5. Appendix A: PowerExchange Interfaces for PowerCenter Tips
  6. Appendix B: Datatypes and Code Pages
  7. Appendix C: PowerExchange Interfaces for PowerCenter Troubleshooting

PowerExchange Interfaces for PowerCenter

PowerExchange Interfaces for PowerCenter

Warm Start Restart Points

Warm Start Restart Points

You can warm start workflows and sessions with the start or restart command from Workflow Manager, Workflow Monitor, or
pmcmd
program.
PWXPC merges the restart tokens provided in the restart token file with any restart information that exists in the state file (nonrelational targets) or the state tables (relational targets), as follows:
  • If the restart token file is empty or does not exist, the restart tokens are determined as follows:
    • If a state file or state table entry does not exist for the session, PWXPC assigns null restart tokens to all sources in the session.
    • If a state file or state table entry exists for some but not all sources in the session, PWXPC assigns the restart tokens in the state file or state tables to the specified sources. For all remaining sources that do not have specified restart tokens, PWXPC assigns the oldest restart point based on the available restart tokens.
    • If a state file or state table entry exists for all sources in the session, PWXPC uses the restart tokens from the state file or state tables.
  • If the restart token file contains explicit override statements, the restart tokens are determined as follows:
    • If no state file or state table entry exists for the session, PWXPC assigns the restart tokens in the explicit override statements to the appropriate sources. For all remaining sources that do not have specified restart tokens, PWXPC assigns the oldest restart point based on the available restart tokens in the restart token file.
    • If a state file or state table entry exists for some but not all sources in the session, PWXPC assigns the restart tokens in the restart token file to the appropriate sources. PWXPC then assigns the restart tokens in the state file or state tables to the specified sources, provided that the token values have not been supplied by the restart token file. For all remaining sources, PWXPC assigns the oldest restart point based on the available restart tokens.
    • If state file or state table entry exists for all sources in the session, PWXPC assigns the restart tokens in the restart token file to the appropriate sources. For all remaining sources, PWXPC assigns the restart tokens from the state file or state tables.
  • If the restart token file contains a special override statement only, PWXPC assigns the restart tokens in the special override statement to all sources.
  • If the restart token file contains a special override statement and explicit override statements, PWXPC assigns the restart tokens in the explicit override statements to the specified sources. PWXPC then assigns the restart tokens in the special override statement to all remaining sources.

0 COMMENTS

We’d like to hear from you!