TMFEXCEPTIONS | NOTMFEXCEPTIONS

Valid for

Replicat

Description

Use TMFEXCEPTIONS when the application performs multiple operations on the same record within the same transaction. Certain application scenarios can cause out-of-order records in the TMF audit trail within a given transaction:

• An insert on a record can occur in the audit trail before a delete on the same primary key, even though the application performed the delete first, followed by the insert (resulting in a duplicate record condition when the insert is performed)

• An update can occur in the audit trail before the insert on the same primary key (resulting in a missing record error when the update is performed)

TMFEXCEPTIONS resolves these conditions.

In the event of a duplicate insert, TMFEXCEPTIONS saves the duplicated insert until the end of the transaction. If a delete with the same primary key is subsequently encountered, the delete is performed, then the saved insert is performed.

In the event of a missing update record, TMFEXCEPTIONS saves the missing update until the end of the transaction. If an insert with the same primary key is subsequently encountered, the insert is performed, then the saved update is performed.

Use NOTMFEXCEPTIONS to turn off the exception processing.

TMFEXCEPTIONS cannot be used with INSERTMISSINGUPDATES.

Default

NOTMFEXCEPTIONS

Syntax

TMFEXCEPTIONS | NOTMFEXCEPTIONS

Example

This example turns on TMFEXCEPTIONS for ORDERS but toggles it off for any MAP statements that are defined later.

TMFEXCEPTIONS
MAP $DATA1.SQLDAT.ORDERS, TARGET $DATA1.MASTER.ORDERS;
NOTMFEXCEPTIONS