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. -
ATCSNcsn| AFTERCSNcsn -
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
ATCSNandAFTERCSN:-
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.
-