RESTART EXTRACT
Use RESTART EXTRACT to stop then start an Extract group.
Syntax
RESTART EXTRACT *group_name* [ATCSN *csn* | AFTERCSN *csn*]group_name
The name of an Extract group or a wildcard (*) to specify multiple groups. For example, T* starts all Extract groups whose names begin with T.
ATCSN csn |
AFTERCSN csn |
Specifies an alternate start point.
ATCSN
Directs Extract to position its start point at the first transaction that has the specified CSN. Any transactions in the data source that have CSN values less than the specified one are skipped.
AFTERCSN
Directs Extract to position its start point at the beginning of the first transaction after the one that has the specified CSN. Any transactions in the data source that have CSN values that are less than, or equal to, the specified one are skipped.
csn
Specifies a CSN value. Enter the CSN value in the format that is valid for the database. Extract abends if the format is invalid and writes a message to the report file. To determine the CSN to supply after an initial load is complete, use the serial identifier at which the load utility completed. Otherwise, follow the instructions in the initial load procedure for determining when to start Extract.
The following are additional guidelines to observe when using ATCSN and AFTERCSN:
-
The CSN is stored in the file header so that it is available to downstream processes.
-
When a record that is specified with a CSN is found, Extract issues a checkpoint. The checkpoint ensures that subsequent Extract start ups begin from the requested location, and not from a point prior to the requested CSN.
-
You must establish a physical start point in the transaction log or trail for Extract with
ADD EXTRACTorALTER EXTRACTbefore usingATCSNorAFTERCSN. These options are intended to be an additional filter after Extract is positioned to a physical location in the data source.
Examples
RESTART EXTRACT financeRESTART EXTRACT finance ATCSN 684993RESTART EXTRACT finance AFTERCSN 684993