Enterprise Replication on Linux woes..

I'm having a lot of trouble getting Informix 9.21 Enterprise Replication up and running under Redhat Linux 6.1 I have setup 3 machines JEFF, MOE, LISA to replicate in UPDATE ANYWHERE mode a table called USER_OBJECTS. I'm just following instructions from the Guide to Informix Enterprise Replication, Replication Examples page 3-9 for the Update Anywhere example. My setup looks like this: SQL HOST FILE ON ALL MACHINES: ----------------------------- g_lisa group - - i=1 gigalisa onsoctcp lisa.gigaton.com informixjdbc g=g_lisa shmlisa onipcshm lisa.gigaton.com unique g=g_lisa jdbclisa onsoctcp lisa.gigaton.com informixjdbc g=g_lisa g_jeff group - - i=2 gigajeff onsoctcp 10.10.10.122 informixjdbc g=g_jeff g_moe group - - i=3 gigamoe onsoctcp moe.gigaton.com informixjdbc g=g_moe Replication Setup -------------- cdr define server --init g_moe cdr define server --connect=gigajeff --init --sync=g_moe g_jeff cdr define server --connect=gigalisa --init --sync=g_moe g_lisa cdr define replicate --conflict=ignore user_objects \\ "gigameta@g_moe:informix.user_objects" "select * from user_objects" \\ "gigameta@g_jeff:informix.user_objects" "select * from user_objects" \\ cdr change replicate --add user_objects \\ "gigameta@g_lisa:informix.user_objects" "select * from user_objects" cdr start replicate user_objects cdr list replicate user_objects REPLICATE SERVER STATE TABLE SELECT ---------------------------------------------------------------------------- user_objects g_moe ACTIVE user_objects select * from user_objectsuser_objects g_jeff ACTIVE user_objects select * from user_objectsuser_objects g_lisa ACTIVE user_objects select * from user_objects[10:45:05][informix@moe:1031] cdr list server SERVER ID STATE STATUS CONNECTION CHANGED ------------------------------------------------------------------ g_jeff 2 Active Connected Mar 27 19:56:45 2000 g_lisa 1 Active Connected Mar 27 22:43:19 2000 g_moe 3 Active Local [10:45:18][informix@moe:1032] SQL EXECUTED ------------- begin work; insert into objects values ('spiderman',1); insert into user_objects (username,password,oid,usedspace) values ('spiderman','spiderman','spiderman','1'); commit work; ERROR MESSAGE RECEIVED ON TWO MACHINE LOG FILES -------------------------------------------------- Tue Mar 28 10:38:22 2000 10:38:22 CDR CDRDS: transaction aborted (Errorreturn from SQL for the commit command) 10:38:28 Checkpoint Completed: duration was 0 seconds. 10:38:28 Checkpoint loguniq 53, logpos 0x25b018 10:43:27 Checkpoint Completed: duration was 0 seconds. 10:43:27 Checkpoint loguniq 53, logpos 0x25c018 I see no errors relating to ATS/RIS at all either, only the above message. The transaction commits on the server I'm running the SQL from, but is not replicated to the other two servers. Time is sychronized on all servers. Anyone have any ideas or experience with ER under Linux? I have opened a case with Informix, but any help at all would be appreciated. Thanks, Jeff Sent via Deja.com http://www.deja.com/ Before you buy.