ER Connection issue

Hi All, I am trying to link an Informix 14.10.FC3 instance running on a RHEL7 server to an Informix 12.10.FC4 instance running on a Solaris 10 server. (I previously had both servers connected, but using the same Informix 12.10) IBM Informix Dynamic Server Version 14.10.FC3 -- On-Line -- Up 03:23:42 -- 3946412 Kbytes IBM Informix Dynamic Server Version 12.10.FC4 -- On-Line -- Up 01:49:52 -- 7032832 KbytesI can connect in both directions using DBACCESS, so the servers can talk to each other. I am attempting to define a new server connection, which will be the original for both systems: cdr define server --connect=i14_srepl_tcp --init g_upg_srepl --nonroot --sync=g_upg_scli On the REHL7 side (i14_srepl_tcp & g_upg_srepl), I amgetting: 14:05:18 CDR connection to server lost, id 12, name <g_upg_scli> Reason: ASF connect error (-27002) 14:05:18 CDR GC: operation sync connect failed (error 5). 14:05:18 CDR GC: synchronization failed (sync abort, shutting down CDR) On the Solaris side (g_upg_scli), the error is just: 14:05:18 (62) connection rejected - no calls allowed for cdraccept if it helps, this is the relevant section of the sqlhosts file on each system: RHEL7: ---------- g_upg_srepl group - - i=42 i14_srepl_tcp onsoctcp rh7data 5142 g=g_upg_srepl g_upg_scli group - - i=12 sylvestercfp_tcp onsoctcp clientdata 5196 g=g_upg_scli Solaris: ---------- g_upg_scli group - - i=12 sylvestercfp_tcp onsoctcp clientdata 5196 g=g_upg_scli g_upg_srepl group - - i=42 i14_srepl_tcp onsoctcp rh7data 5142 g=g_upg_srepl Thanks Much, Michael Hoffman ------------------------------ Michael Hoffman ------------------------------ #Informix

Can you bi-directional connect without a password from dbaccess using the group/informix servers name ? But 27002 is engine is Queisicent – needs to be online Cheers Paul

Hi Paul, Yes, I can connect bi-directionally via dbaccess without a password. The Quiescent error message is a red herring. Both instances are Online. (That's why I included the onstat - messages :-) ) Thanks, Mike ------------------------------ Michael Hoffman ------------------------------

We have a WINNER!!!!! Thanks Jacques!!! Jacques had issues replying to the thread, so he replied privately. I'm dropping it here so others can learn from my error. --------------- Message From: Jacques Renaut For some reason it doesn't seem like I can respond to your post, so I'm going to try and reply privately. I think the issue is simply that you haven't done the cdr define server 1st on server that you are trying to use as the sync server in the "cdr define server" command you listed. I believe if you do the define server on that machine 1st, then the command you are trying to run will then work. So if you are using the sync in your cdr define server command, that server needs to already have been added. ------------------------------ Jacques Renaut ------------------------------ ------------------------------ Michael Hoffman ------------------------------

Is the 'master' defined ? Cheers Paul

I just attempted something similar to what I think you are doing. I think the issue is you are trying to define the server first on server i14_srepl_tcp/g_upg_srepl, but you are telling it the sync server is going to be sylvestercfp_tcp/g_upg_scli, but you haven't done the cdr define server on sylvestercfp_tcp/g_upg_scli. from my test doing something similar (without the --nonroot) cdr define server --init g_er2 --sync=g_er1 from MSGPATH of g_er1: 09:06:02 (93) connection rejected - no calls allowed for cdraccept from MSGPATH of g_er2: 09:05:59 DDR Log Snooping - Snooping started in log 195 09:06:01 CDR: WARNING: Server is configured with /tmp as the ATS and RIS directory. If /tmp is configured as the swap space of this machine then it can affect the machine's performance if ER generated a large amount of files in this directory. 09:06:02 CDR connection to server lost, id 101, name <g_er1> Reason: ASF connect error (-27002) 09:06:02 CDR GC: operation sync connect failed (error 5). 09:06:02 CDR GC: synchronization failed (sync abort, shutting down CDR) 09:06:03 CDR NIF Shutdown: connections all shutdown. 09:06:03 CDR The NIF sub-component has shut down. 09:06:04 DDR Log Snooping - Shutdown 09:06:04 CDR shutdown complete So in my case, I would need to do my cdr define server 1st on g_er1. ------------------------------ Jacques Renaut ------------------------------