Sorry, meant to say "save" ......... d'oh !

-----Original Message-----
From: owner-informix-list@iiug.org [mailtowner-informix-list@iiug.org]
On Behalf Of Dirk Moolman
Sent: 16 February 2005 11:43 AM
To: Alex Daman
Cc: informix-list@iiug.org
Subject: RE: Informix Enterprise Replication

Just to safe yourself possible headaches - make sure your Solaris
patches are not old / out dated - caused LOTS of problems for me !


-----Original Message-----
From: owner-informix-list@iiug.org [mailtowner-informix-list@iiug.org]
On Behalf Of Alex Daman
Sent: 16 February 2005 09:09 AM
To: informix-list@iiug.org
Subject: Informix Enterprise Replication

Hi All,

Is there anyone out there who has setup ER on 7.31.UD1. Im trying to
implement a proof of concept for replicating two of our sites. Im runnig

with Online 7.31.UD1 on Sun Solaris platform.
I have configured my sqlhosts files according to the Replication guide,
see
below:

############### SQLHOSTS FILE #######################

g_pocmel group -
-
i=1
pocmel ontlitcp mel-log
inf_repl g=g_pocmel
pocmel_shm onipcshm mel-log pocmel
g=g_pocmel
#
g_pocsyd group -
-
i=2
pocsyd ontlitcp syd-log
inf_repl
g=g_pocsyd
pocsyd_shm onipcshm syd-log pocsyd
g=g_pocsyd

############### END OF FILE ######################

I have tested both connections between each other and both are ok.
However,
when I try and run the any cdr command, I get the following error:

cdr define server --send=quedbs --recv=quedbs --init pocmel
INFORMIXSERVER not defined in environment


$ cdr list server
INFORMIXSERVER not defined in environment

No matter what cdr command I run, I get this type of response back. My
INFORMIXSERVER variable is of course set, however I think the problem
lies
somewhere else. Very frustrated at the moment

Can anyone help out here! Or send me some white papers (not from the
Replication guide, I have read this guide over and over !)

Thanks in advance.

Alex




sending to informix-list

sending to informix-list

There may be issues with your DBSERVERNAME having to be the tcp
connection.

Do not have your shared memory DBSERVERNAME / ALIAS in the group

# tbp_731a instance
cdr_tbps1 group - - i=10
tbp_731a_tcp onsoctcp tbp tbp_731a_tcp g=cdr_tbps1
tbp_731a_shm onipcshm tbp tbp_731a_shm
# tbp_731b instance
cdr_tbps2 group - - i=20
tbp_731b_tcp onsoctcp tbp tbp_731b_tcp g=cdr_tbps2
tbp_731b_shm onipcshm tbp tbp_731b_shm