CDR servers on SDS primaries will not connect
Posted in 2009
Topics: High Availability & Replication, Versions, Editions & End-of-Life
IBM Informix Dynamic Server Version 11.50.FC3X8 We have historically combined our test and development environments. But I have been tasked with separating them. To that end we have created test and dev SDS servers. Howerver, one of the projects requires that the test and dev data be sync'd so I am attempting to set up Enterprise Replication on that db. I have defined the templates but when I attempt to realize them on pstest1 I get: undefined server - (g_psdev) command failed -- undefined server (37) I have set up CDR servers g_pstest and g_psdev on SDS primary servers pstest1 and psdev1 respectively. Both of them seem to be working but I cannot get either to connect to the other. I initially define both servers on pstest1; on previous instances (IDS 10.0) without SDS this worked great. These are the command line results from psdev1: -> cdr list server SERVER ID STATE STATUS QUEUE CONNECTION CHANGED ----------------------------------------------------------------------- g_psdev 60 Active Local 0 -> cdr list server --connect=g_pstest SERVER ID STATE STATUS QUEUE CONNECTION CHANGED ----------------------------------------------------------------------- g_pstest 50 Active Local 0 Notice that I can access either (via --connect) from the other. But they will not connect. -> cdr connect server -c g_pstest g_psdev command failed -- undefined server (37) -> cdr connect server -c g_psdev g_pstest command failed -- undefined server (37) I have tried any number of the possible command option permutations always with the same result. Does anyone out there have any ideas? I hope you're not ALL at the conference.
display your sqlhost file. All of the nodes within the MACH11 cluster would need to be configured into a group so that ER can correctly attac= h to whatever the primary is. = "BEVIS KENNEDY" = <bkennedy@utah.go = v> = To Sent by: ids@iiug.org = ids-bounces@iiug. = cc org = Subj= ect CDR servers on SDS primaries wil= l 04/22/2009 03:25 not connect [15583] = PM = = = Please respond to = ids@iiug.org = = = IBM Informix Dynamic Server Version 11.50.FC3X8 We have historically combined our test and development environments. Bu= t I have been tasked with separating them. To that end we have created test= and dev SDS servers. Howerver, one of the projects requires that the test a= nd dev data be sync'd so I am attempting to set up Enterprise Replication on t= hat db. I have defined the templates but when I attempt to realize them on pste= st1 I get: undefined server - (g_psdev) command failed -- undefined server (37) I have set up CDR servers g_pstest and g_psdev on SDS primary servers pstest1 and psdev1 respectively. Both of them seem to be working but I cannot g= et either to connect to the other. I initially define both servers on pste= st1; on previous instances (IDS 10.0) without SDS this worked great. These are = the command line results from psdev1: -> cdr list server SERVER ID STATE STATUS QUEUE CONNECTION CHANGED -----------------------------------------------------------------------= g_psdev 60 Active Local 0 -> cdr list server --connect=3Dg_pstest SERVER ID STATE STATUS QUEUE CONNECTION CHANGED -----------------------------------------------------------------------= g_pstest 50 Active Local 0 Notice that I can access either (via --connect) from the other. But the= y will not connect. -> cdr connect server -c g_pstest g_psdev command failed -- undefined server (37) -> cdr connect server -c g_psdev g_pstest command failed -- undefined server (37) I have tried any number of the possible command option permutations alw= ays with the same result. Does anyone out there have any ideas? I hope you'= re not ALL at the conference. ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =
psdev1:
g_psdev group - - i=60
psdev1 onsoctcp 172.16.51.9 1546 g=g_psdev
psdev2 onsoctcp 172.16.51.10 1546
psdev_soc onsoctcp 172.16.51.9 1547 g=g_psdev
psdev_main onsoctcp 172.16.51.9 1548 g=g_psdev
psdev_rpt onsoctcp 172.16.51.9 1550 g=g_psdev
g_pstest group - - i=50
pstest1 onsoctcp 172.16.51.6 1546 g=g_pstest
pstest2 onsoctcp 172.16.51.7 1546
pstest3 onsoctcp 172.16.51.8 1546
======================================================================
pstest1:
g_pstest group - - i=50
pstest1 onsoctcp 172.16.51.6 1546 g=g_pstest
pstest_soc onsoctcp 172.16.51.6 1547 g=g_pstest
pstest_main onsoctcp 172.16.51.6 1548 g=g_pstest
pstest_rpt onsoctcp 172.16.51.6 1550 g=g_pstest
g_psdev group - - i=60
psdev1 onsoctcp 172.16.51.9 1546 g=g_psdev