RE: Informix Enterprise Replication
Sorry, meant to say "save" ......... d'oh !
-----Original Message-----
From: owner-informix-list@iiug.org [mailto:owner-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 [mailto:owner-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 serverINFORMIXSERVER 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 :D
# 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