Universal Cache User Guide : IBM InfoSphere CDC for solidDB® reference : Conflict resolution audit table : Structure of the conflict resolution audit table
  
Structure of the conflict resolution audit table
You can use the TS_CONFAUD table to track how conflict resolution affected 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 problems in your conflict resolution strategy.
Conflict detection and resolution is configured in Management Console. For more information, see your Management Console documentation.
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
This field is blank.
TGTSCHEMA
The schema or library for the target table.
TGTNAME
The name of the target table.
OPTYPE
The row-level operation on the source that caused the conflict. The value is one of:
1—a row was inserted into the source table.
2—a row was updated on the source table.
3—a row was deleted from the source table.
CNFTYPE
The type of conflict that was detected. The value is one of:
1—a row was inserted into the source table. The key for that row already exists in the target table.
2—a row was updated or deleted on the source table. The key for that row does not exist in the target table.
3—a row was updated or deleted on the source table. The images of the source and target tables do not match.
4—an unexpected conflict was detected.
RESMTD
The conflict resolution method that was used. The value is one of:
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. See your IBM InfoSphere CDC documentation for more information about these methods.
CNFRES
Indicates if the conflict was resolved. The value is one of:
Y—the conflict was resolved.
N—the conflict was not resolved.
BEFOREIMG
A representation of the row in the source table before it was changed.
BEFORETRNC
Indicates if the before image stored in BEFOREIMG was truncated. The value is one of:
Y—the value was truncated.
N—the value was not truncated.
AFTERIMG
A representation of the row in the source table after it was changed.
AFTERTRNC
Indicates if the after image stored in AFTERIMG was truncated. The value is one of:
Y—the value was truncated.
N—the value was not truncated.
TGTIMG
A representation of the row in the target table before replication occurred.
TGTTRNC
Indicates if the image stored in TGTIMG was truncated. The value is one of:
Y—the value was truncated.
N—the 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 value is one of:
Y—the value was truncated.
N—the value was not truncated.
See also
Conflict resolution audit table