|
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. See Row image format.
for more information about the format of this column.
|
|
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. See Row image format.
for more information about the format of this column.
|
|
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. See Row image format.
for more information about the format of this column.
|
|
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. For more information about the format of this column, see Row image format.
|
|
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.
|