The scenario:-
I have one source (on Unix) and 2 target databases F01 and F02 (in Windows). I am testing replication between them.

The test:-
I am testing the situation where I update the same rows in the two target databases. This is to test how DB2 replication handles update conflicts. I update the same number of rows in a table and replicate them.

1. I replicate F02 first and then F01. F02 replicates without any error. F01 replicates with the error message:-

2008-02-04-11.32.48.129000 ASN1067E APPLY "F01" : "WorkerThread". The Apply pro
gram has detected update conflicts and compensated rejected transactions. See th
e unit-of-work table for details. The error code is "456712".

2008-02-04-11.32.49.004000 ASN1025I APPLY "F01" : "WorkerThread". The Apply pro
gram completed processing for subscription set "F01_SUB"("F"). The return code i
s "-1".
2008-02-04-11.32.50.176000 ASN1025I APPLY "F01" : "WorkerThread". The Apply pro
gram completed processing for subscription set "F01_SUB"("F"). The return code i
s "0".

2. I replicate F01 first then F02. F01 replicates without any error. F02 replicates with the error message:-

2008-02-06-06.10.52.503000 <CPCPCH(8D/07)> ASN1001E APPLY "F02" : "WorkerThread
". The Apply program encountered an SQL error. The ERRCODE is "8D0107". The SQLS
TATE is "23505". The SQLCODE is "-803". The SQLERRM is "1ÿASN.IBMSNAP_COMPENSATE
". The SQLERRP is "SQLDMISR". The server name is "". The table name is "ASN.IBMS
NAP_COMPENSATE".
2008-02-06-06.10.52.518000 <CPPSET(45/00)> ASN1025I APPLY "F02" : "WorkerThread
". The Apply program completed processing for subscription set "F02_SUB"("S"). T
he return code is "-1".

The F01_SUB("F") is the subset for target to source replication whereas F02_SUB("S") is the subset for source to target replication.

I dont know why I am getting two different types of error messages for the same tests. Can any one help me out with the 2nd scenario where I replicate F01 first and then F02? Why I get an error on ASN.IBMSNAP_COMPENSATE in this case whereas the 1st scenario handles update conflicts and resolves it?

Thanks a lot,
Debayan