ER Replication and IDS 9.4
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
coleas wrote:
> 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=200> mt ontlitcp mirrortest 1034 g=g_mt
> g_mirror group - - i=100
> mirror ontlitcp yancy 1036 g=g_mirror
I question putting 'mt' in the sqlhost file twice. Perhaps something
like this would be better....
mt onipcshm mirrortest mtshm
g_mt group - - i=200mt_tcp onsoctcp mirrortest 1034 g=g_mt
etc....
>
> /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