ER Replication and IDS 9.4
A user setting up Enterprise Replication on IDS 9.4 under Ubuntu couldn't define the first server: 'cdr define server -c mt -I g_mt' returned "server not defined in sqlhosts (35)", and after renaming entries it failed with error 25507. Madison Pruet pointed out the duplicate 'mt' entry in sqlhosts and, more importantly, that the group entries used ontlitcp when Linux/Ubuntu requires onsoctcp. Switching the protocol let the server initialise. A follow-up confirmed that nightly onbar level-0 backups can run with ER active (logs are tracked for ER), so replication needn't be suspended.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi
I am testing an ER replication scenario but am getting an error defining the
1st server
Error im getting.. command failed -- server not defined in sqlhosts (35)
the command I'm using .. cdr define server -c mt -I g_mt
the critical files
/opt/informix/etc/sqlhosts
mt onipcshm mirrortest mtshm
mt_tcp onsoctcp mirrortest mt_tcp
g_mt group - - i=200mt ontlitcp mirrortest 1034 g=g_mt
g_mirror group - - i=100
mirror ontlitcp yancy 1036 g=g_mirror
/etc/services
mt_tcp 1034/tcp # informix db
mtshm 1035/tcp # informix db
yancy 1036/tcp # mirror server
mirrortest 1037/tcp # informix db
/etc/hosts
127.0.0.1 localhost
192.168.3.91 mirrortest
192.168.3.110 yancy
what am I doing incorrectly ?
Im sure its looking me in the face but I cant see it ..
thanks for any help
Don't know for sure, but I question having 'mt' in the sqlhost file twi=
ce.
=
"BRETT SIMPSON" =
<brett.simpson@ac =
trol.com.au> =
To
Sent by: ids@iiug.org =
ids-bounces@iiug. =
cc
org =
Subj=
ect
ER Replication and IDS 9.4 [171=
23]
09/21/2009 07:08 =
PM =
=
=
Please respond to =
ids@iiug.org =
=
=
Hi
I am testing an ER replication scenario but am getting an error definin=
g
the
1st server
Error im getting.. command failed -- server not defined in sqlhosts (35=
)
the command I'm using .. cdr define server -c mt -I g_mt
the critical files
/opt/informix/etc/sqlhosts
mt onipcshm mirrortest mtshm
mt_tcp onsoctcp mirrortest mt_tcp
g_mt group - - i=3D200mt ontlitcp mirrortest 1034 g=3Dg_mt
g_mirror group - - i=3D100
mirror ontlitcp yancy 1036 g=3Dg_mirror
/etc/services
mt_tcp 1034/tcp # informix db
mtshm 1035/tcp # informix db
yancy 1036/tcp # mirror server
mirrortest 1037/tcp # informix db
/etc/hosts
127.0.0.1 localhost
192.168.3.91 mirrortest
192.168.3.110 yancy
what am I doing incorrectly ?
Im sure its looking me in the face but I cant see it ..
thanks for any help
***********************************************************************=
********
Forum Note: Use "Reply" to post a response in the discussion forum.
=
thanks for the quick reply :-)
Yea I though that could be the issue but when I use this sqlhosts file
mt onipcshm mirrortest mtshm
mt_tcp onsoctcp mirrortest mt_tcp
g_rmt group - - i=200rmt ontlitcp mirrortest 1034 g=g_rmt
g_rmirror group - - i=100
rmirror ontlitcp yancy 1034 g=g_rmirror
and use this command
cdr define server -c rmt -I g_rmt
I get this error
connect to rmt failed *Error* <25507> is not a known Enterprise Replication
error (25507)
which is even stranger...
What hardware is this? Should it be onsoctcp or ontlitcp?
=
"BRETT SIMPSON" =
<brett.simpson@ac =
trol.com.au> =
To
Sent by: ids@iiug.org =
ids-bounces@iiug. =
cc
org =
Subj=
ect
Re: ER Replication and IDS 9.4 =
09/21/2009 07:28 [17125] =
PM =
=
=
Please respond to =
ids@iiug.org =
=
=
thanks for the quick reply :-)
Yea I though that could be the issue but when I use this sqlhosts file
mt onipcshm mirrortest mtshm
mt_tcp onsoctcp mirrortest mt_tcp
g_rmt group - - i=3D200rmt ontlitcp mirrortest 1034 g=3Dg_rmt
g_rmirror group - - i=3D100
rmirror ontlitcp yancy 1034 g=3Dg_rmirror
and use this command
cdr define server -c rmt -I g_rmt
I get this error
connect to rmt failed *Error* <25507> is not a known Enterprise Replica=
tion
error (25507)
which is even stranger...
***********************************************************************=
********
Forum Note: Use "Reply" to post a response in the discussion forum.
=
running on Ubuntu 8.04.2
Isn't Ubuntu using sockets? Shouldn't it be using onsoctcp? = "BRETT SIMPSON" = <brett.simpson@ac = trol.com.au> = To Sent by: ids@iiug.org = ids-bounces@iiug. = cc org = Subj= ect Re: ER Replication and IDS 9.4 = 09/21/2009 07:53 [17127] = PM = = = Please respond to = ids@iiug.org = = = running on Ubuntu 8.04.2 ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =
thanks madison
finally got the server initialised :-)
quick question...
If I use onbar for a level 0 each night will that work at the same time as
replication or do I need to suspend relication until the level 0 finishes ?
the backup will track the logs according to what ER needs - much like i=
t
does with the oldest open transaction with systems that don't have ER.
Basically - it works the same. You can keep ER on.
=
"BRETT SIMPSON" =
<brett.simpson@ac =
trol.com.au> =
To
Sent by: ids@iiug.org =
ids-bounces@iiug. =
cc
org =
Subj=
ect
Re: ER Replication and IDS 9.4 =
09/21/2009 09:06 [17129] =
PM =
=
=
Please respond to =
ids@iiug.org =
=
=
thanks madison
finally got the server initialised :-)
quick question...
If I use onbar for a level 0 each night will that work at the same time=
as
replication or do I need to suspend relication until the level 0 finish=
es ?
***********************************************************************=
********
Forum Note: Use "Reply" to post a response in the discussion forum.
=