Listing of the conflict with the LIST CONFLICT command
To view the actual SQL and other details associated with of the transaction that is causing the conflict:
| Panelnoformat | ||
|---|---|---|
| ||
dbvrep> LIST CONFLICT |
or by specifying the actual conflict id:
| Panelnoformat | ||
|---|---|---|
| ||
dbvrep> LIST CONFLICT 345 |
or by specifying last:
| Panelnoformat | ||
|---|---|---|
| ||
dbvrep> LIST CONFLICT LAST |
...
Viewing all the conflicts
It is also possible to obtain the conflict information directly from the Dbvisit Replicate repository. Logon to the apply (target database) as the Dbvisit Replicate schema owner (dbvrep) and query table:
| Panelnoformat | ||
|---|---|---|
| ||
DBRSAPPLY_CONFLICT_LOG |
This lists all the conflicts encountered, including failing SQL.The column SQL_TEXT contains the actual SQL statement that is run against the target database and includes the bind variables.