Table of Contents

Search

  1. Preface
  2. Change Data Capture Introduction
  3. PowerExchange Listener
  4. PowerExchange Condense
  5. DB2 for i5/OS Change Data Capture
  6. Remote Logging of Data
  7. Introduction to Change Data Extraction
  8. Extracting Change Data
  9. Monitoring CDC Sessions
  10. Managing Change Data Extractions
  11. Tuning CDC Sessions
  12. Appendix A: DTL__CAPXTIMESTAMP Time Stamps

CDC Guide for i5/OS

CDC Guide for i5/OS

Determining the Restart Tokens for Warm Start Processing

Determining the Restart Tokens for Warm Start Processing

When you warm start a CDC session, PWXPC uses the state tables and state file, in conjunction with restart token file, to determine the restart tokens for all sources.
More specifically, PWXPC uses one of the following methods to determine the restart tokens:
  • If the restart token file is empty or does not exist and there is no matching entry in a state table or state file, PWXPC assigns null restart tokens to all sources in the session.
  • If the restart token file is empty or does not exist and if some but not all sources have a matching entry in a state table or a state file, PWXPC performs the following processing:
    • Assigns any restart tokens found in a state table and state file to the appropriate sources.
    • Assigns the oldest available restart point to all sources that do not have restart tokens.
  • If the restart token file is empty or does not exist and if all sources have an entry in a state table or state file, PWXPC uses the restart tokens from the state tables or state file.
  • If the restart token file contains explicit override statements and no sources have a matching entry in a state table or no state file, PWXPC performs the following processing:
    • Assigns the restart tokens in the explicit override statements to the specified sources.
    • Assigns the oldest supplied restart point to all sources that do not have restart tokens.
  • If the restart token file contains explicit override statements and if some but not all sources have a matching entry in a state table or a state file, PWXPC performs the following processing:
    • Assigns the restart tokens in the explicit override statements to the specified sources.
    • Assigns restart tokens from a state table or state file to the appropriate sources, provided that the tokens have not been supplied in the restart token file.
    • Assigns the oldest available restart point to all sources that do not have restart tokens supplied in the restart token file or from a state table or state file.
  • If the restart token file contains explicit override statements and if all sources have an entry in a state table or a state file, PWXPC performs the following processing:
    • Assigns the restart tokens in the explicit override statements to the specified sources.
    • Assigns the restart tokens from state tables or the state file to all remaining sources that do not have restart tokens supplied in the restart token file.
  • If the restart token file contains only the special override statement, 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 performs the following processing:
    • Assigns the restart tokens in the explicit override statements to the specified sources.
    • Assigns the restart tokens in the special override statement to all remaining sources.

0 COMMENTS

We’d like to hear from you!