The scenario that I was think of is the one where two users, each on different servers, modify the same row during the same point in time. They may modify seperate columns of the same row but since we are doing full row replication, a requirement for update anywhere ER, the whole row is replaced when it gets replicated.

I just tested this scenario and you are correct that an ATS file was generated. My concern is invalid since ER will not let that happen. It makes sense now I just has to talk it out and test it. Thanks Madison.

----- Original Message ----
From: Madison Pruet <mpruet@comcast.net>
To: informix-list@iiug.org
Sent: Monday, February 27, 2006 5:03:03 PM
Subject: Re: Enterprise Replication Conflict Notification

Hope you can make it to IDUG. We're getting a 'replication' half-day that
will be covering these types of issues.

If there is a situation in which the replicated row can not be applied
because it was in conflict, then you should be able to to use the ATS/RIS
files. However, you need to understand the meaning of conflict resolution.

CR fires anytime there is a local row and a row to be applied coming through
replication. The local row might just be an earlier copy of row which was
earlier replicated. I suspect that by conflict, you mean that you want to
know when a conflict occurs in which the replicated row was not applied on
the target. Is that the case? If so, then the ATS/RIS file should be what
you are wanting to get.


"DL Redden" <redden96@yahoo.com> wrote in message
news:mailman.1.1141079720.18205.informix-list@iiug.org...
> My company is in the process of implementing a 7 instance, update-anywhere
ER topology using timestamp conflict resolution. We have decided that we
want/need to know when and if a conflict occurs.
>
> I asked an IBM resource if IDS offered an alert of some mechanism for
trapping the fact that a conflict occured and the answer I recieved was no.
However he did suggest that I could use timestamp + SP log info about the
conflict.
>
> Is there anyone already doing something like this?
> I would also like to know if there is anyone with ER monitoring scripts
that they would be willing to share?
>
> Regards,
>
> DL Redden
>
>


_______________________________________________
Informix-list mailing list
Informix-list@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list