Valid for
Replicat
Description
In both TMF and non-TMF applications, an anomaly can occur in which an insert and subsequent update to the same record appear in reverse order in the log trail or extract trail. When processing such reversed data, Replicat processes the update first and this results in a "record not found" error. TMFEXCEPTIONS
can be used to hold the update in anticipation of the insert. With TMF audit trails, Replicat will hold such transactions until the end of the TMF transaction. With non-TMF audit trails, however, there is no TMF transaction, so the number of seconds or centiseconds needs to be set using one of the REVERSEWINDOW
parameters.
REVERSEWINDOW
enables Replicat to hold the transactions for a specified number of seconds or centiseconds (the reverse window) without attempting to process them. If a subsequent insert is found within the reverse window, the insert is applied to the target file followed by the update and no error is recorded. If the reverse window expires without finding a matching insert, the process abends or discards the transaction depending on the selected option.
REVERSEWINDOWSECS
or REVERSEWINDOWCSECS
alone will not trigger Replicat to hold exception transactions. For this to work you must also:
Set TMFEXCEPTIONS
on for that file.
Use NOAUDITREPS
to ensure a non-audited target.
If both REVERSEWINDOW
and TMFEXCEPTIONS
are specified, but NOAUDITREPS
is not, a message is generated that REVERSEWINDOWSECS
is ignored. TMFEXCEPTIONS
will still be applied.
Note:
REVERSEWINDOWSECS
should only be used when the source is a non-TMF audited database. It should not be used when the source is a TMF audit trail.
Default
ABENDEXPIREDWINDOW
Syntax
{REVERSEWINDOWSECS seconds | REVERSEWINDOWCSECS cseconds} [ABENDEXPIREDWINDOW | DISCARDEXPIREDWINDOW]
REVERSEWINDOWSECS
seconds
| REVERSEWINDOWCSECS
cseconds
REVERSEWINDOWSECS
seconds
specifies the wait time in seconds. The range is 1 to 30 seconds and the recommended setting is 1.
REVERSEWINDOWCSECS
cseconds
specifies it in centiseconds. The range is 10 to 100 centiseconds and the recommended setting is 10.
ABENDEXPIREDWINDOW
Causes Replicat to abend at the expiration of th
e wait time.
Note:
Using this option will cause Replicat to checkpoint to the current position in the trail.
DISCARDEXPIREDWINDOW
Causes Replicat to discard the expired record and continue. This may be the preferred option if it is important to minimize Replicat downtime and file inconsistencies can be corrected at a later time.