Queue Collision Report
The Queue Collision Report lists collision conflicts that exist on the local database. By reviewing the report, you can decide if you want to manually or automatically resolve each collision.
The report lists all collisions found from the distribution queue. It reports the type of collision (insert, update, delete) and the values of the columns in the local database, followed by the remote database where the collision occurred (number, node, name) and the values of the columns in the remote database. The end of the report displays the total number of collisions found.
Following is an example of the Queue Collision Report:
Ingres Replicator
Queue Collision Report
Local Database: 10 hq
INSERT Collision for table rep_dba.book_list
Local database
Source DB: 10 Transaction ID: 811660429 Sequence No: 1
*name: Doe, John
manager: Jones, Ashley
hourly_rate: 23.000
title: Programmer
Remote Database Number 20 Node: lon, Name: europe
*name: Doe, John
manager: Wolfe, Neal
hourly_rate: 25.000
title: Programmer
INSERT Collision for table rep_dba.book_list
Local database
Source DB: 10 Tansaction ID: 811660837 Sequence No: 1
*name: Doe, Jane
manager: Wolfe, Neal
hourly_rate: 47.000
title: Sr Programmer
Remote Database Number 20 Node: lon, Name: europe
*name: Doe, Jane
manager: Ashley, Jones
hourly_rate: 45.000
title: Sr Programmer
2 collision(s) found.