Before you begin extracting change data, you must create restart tokens to indicate the extraction start point.
The optimal start point matches the point in the change stream at which you last synchronized the source and target. This point marks the end of the change stream, or current end-of-log (EOL), if you stop update activity on the source, as recommended, until after target materialization and restart token generation are complete.
To create current restart tokens for the current EOL, use one the following methods:
PWXPC restart token file
To generate current restart tokens for a CDC session that uses real-time or continuous extraction mode, specify the CURRENT_RESTART option on the RESTART1 and RESTART2 special override statements in the PWXPC restart token file. When the CDC session runs, PWXPC requests that PowerExchange provide restart tokens for the current EOL. PWXPC uses this restart information to locate the extraction start point.
Database row test
In the PowerExchange Navigator, perform a database row test with a SELECT CURRENT_RESTART SQL statement.
DTLUAPPL utility
Run the DTLUAPPL utility with the GENERATE RSTKKN option.
If you use the DTLUAPPL utility or PowerExchange Navigator to generate restart tokens, enter the token values in the PWXPC restart token file before you start the CDC session.