2.198 REVERSEWINDOWSECS | REVERSEWINDOWCSECS

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 the 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.