Structure of the conflict resolution audit table

You can use the TS_CONFAUD table to track how conflict resolution affects your target table.

For example, you can query the AFTERIMG column to see when a change was made to the target table. Then you can review the contents of the BEFOREIMG and AFTERIMG columns to see the change on the source table that resulted in the data on the target table. This can help in identifying issues in your conflict resolution strategy.

Conflict detection and resolution is configured in Management Console.

The structure of the TS_CONFAUD table is as follows:
Column Description
CNFTIME The date and time on the target when the conflict was detected.
SRCTIME The time the conflicting data was applied to the source table.
SRCSYSID The source ID of the subscription.
SRCSCHEMA The schema or library name for the source table.
SRCNAME The name of the source table.
SRCMEMBER

The name of the source table.
TGTSCHEMA The schema or library for the target table.
TGTNAME The name of the target table.
TGTMEMBER

This column is only used for the IBM® i platform.
OPTYPE The row-level operation on the source that caused the conflict. The following list indicates the possible values:
1
Inserted into the source table.
2
Updated on the source table.
3
Deleted from the source table.
CNFTYPE The type of conflict that was detected. The following list indicates the possible values:
1
Inserted into the source table. The key for that row already exists in the target table.
2
Updated or deleted on the source table. The key for that row does not exist in the target table.
3
Updated or deleted on the source table. The images of the source and target tables do not match.
4
Unexpected conflict was detected.
RESMTD The conflict resolution method that was used. The following list indicates the possible values:
1
Source wins
2
Target wins
3
Largest value wins
4
Smallest value wins
5
User exit

If the resolution method was None, then a row will not be entered into this table.

CNFRES Indicates if the conflict was resolved. The following list indicates the possible values:
Y
Conflict was resolved.
N
Conflict was not resolved.
BEFORETRNC

Indicates if the before image stored in BEFOREIMG was truncated. The following list indicates the possible values:

Y
Value was truncated.
N
Value was not truncated.
BEFOREIMG A representation of the row in the source table before it was changed.
AFTERTRNC

Indicates if the after image stored in AFTERIMG was truncated. The following list indicates the possible values:

Y
Value was truncated.
N
Value was not truncated.
AFTERIMG A representation of the row in the source table after it was changed.
TGTIMG A representation of the row in the target table before replication occurred.
TGTTRNC Indicates if the after image stored in TGTIMG was truncated. The following list indicates the possible values:
Y
Value was truncated.
N
Value was not truncated.
WINIMG A representation of the final row in the target table after conflict resolution has occurred.
WINTRNC Indicates if the image stored in WINIMG was truncated. The following list indicates the possible values:
Y
Value was truncated.
N
Value was not truncated.