ER error

Posted in 2006

FRANK — Tue, 19 Dec 2006 17:40:36 — source: IIUG Forums & Mailing Lists

Hi, Madison and other experts, I have defined new replication servers thousands times without any issues for a couple of years! From yesterday, I was going to setup a ER in a new box, when I run the command, it displayed, informix@otto $ cdr define server --init ncdcprd_grp command failed -- server not defined in sqlhosts (35) The online log is, 17:43:59 Building 'syscdr' database ... 17:43:59 Loading Module <SPLNULL> 17:43:59 'syscdr' database built successfully. 17:43:59 CDR current servername not found 17:43:59 Unloading Module <SPLNULL> My sqlhosts file is, osdint1_grp group - - i=1 osdint1_er onsoctcp 192.168.203.87 online9170 s=6,g=osdint1_grp osdint1_tcp onsoctcp 192.168.203.87 online9150 osdint2_grp group - - i=2 osdint2_er onsoctcp dora-dat online9173 s=6,g=osdint2_grp osdint2_tcp onsoctcp dora-dat online9153 osdint2 onipcshm dora-dat service9153 ncdcprd_grp group - - i=3 ncdcprd_er onsoctcp 192.168.213.36 online9183 s=6,g=ncdcprd_grp ncdcprd_tcp onsoctcp 192.168.213.36 online9180 ncdcprd onipcshm 192.168.213.36 service9180 I used similar command and the same sqlhosts file in another box, started a ER server successfully. I have no idea why it complains that. Thanks, Frank Program Name: onstat Build Version: 10.00.UC5 Build Number: N202 Build Host: ibm6c1b Build OS: AIX 5.2 Build Date: Thu May 18 00:09:08 CDT 2006 GLS Version: glslib-4.00.UC8