ER help
I am trying to set up replication and I am getting some errors that I don't know about. Has anyone run across this problem, and if so can you offer some advice? server 1 - beaker SCO_SV IDS Ver 7.30.UC2 $INFORMIXDIR/etc/sqlhosts g_beaker group - - i=1 beaker_shm olipcshm beaker srv_agent g=g_beaker beaker oltlitcp beaker sql_turbo g=g_beaker g_gonzo group - - i=2 gonzo oltlitcp gonzo sql_turbo g=g_gonzo server 2 - gonzo HP-UX 11 IDS Ver. 7.30.UC7 $INFORMIXDIR/etc/sqlhosts g_gonzo group - - i=2 gonzo_shm onipcshm gonzo srv_agent g=g_gonzo gonzo onsoctcp *gonzo sql_turbo g=g_gonzo g_beaker group - - i=1 beaker onsoctcp beaker sql_turbo g=g_beaker /etc/hosts.equiv on gonzo beaker informix While on beaker I am able to define beaker fine using cdr define server -- init g_beaker But when I try to define gonzo from beaker using cdr define server -connect gonzo -init -sync g_beaker g_gonzo I receive this error message command failed -- invalid server (47) %finderr 47 -47 Address family not supported by protocol family. An operating-system error code with the meaning shown was unexpectedly returned to the database server. If the error recurs, please note all circumstances and contact Informix Technical Support. Thanks for any help anyone may offer. Andrew Ford Informix Database Administrator Simplified Telesys 5000 Plaza on the Lake Suite 170 Austin, TX 78746 United States (512) 425-9767
First of all, I would suggest using 7.31 or 9.2 for ER. The 7.31UC4 SCO release is scheduled for the end of October. The errors that you get from most ER commands are found in $INFORMIXDIR/incl/esql/cdrerr.h. From there you will see that error code 47 is Invalid Server. I normally use only the group names for er commands. Also, I normally use the "short" format of the commands. You might try the following.. cdr define server -c g_gonzo -I -S g_beaker g_gonzo Andrew Ford wrote: > I am trying to set up replication and I am getting some errors that I don't know about. Has anyone run across this problem, and if so can you offer some advice? > > server 1 - beaker > SCO_SV > IDS Ver 7.30.UC2 > > $INFORMIXDIR/etc/sqlhosts > > g_beaker group - - i=1 > beaker_shm olipcshm beaker srv_agent g=g_beaker > beaker oltlitcp beaker sql_turbo g=g_beaker > > g_gonzo group - - i=2 > gonzo oltlitcp gonzo sql_turbo g=g_gonzo > > server 2 - gonzo > HP-UX 11 > IDS Ver. 7.30.UC7 > > $INFORMIXDIR/etc/sqlhosts > > g_gonzo group - - i=2 > gonzo_shm onipcshm gonzo srv_agent g=g_gonzo > gonzo onsoctcp *gonzo sql_turbo g=g_gonzo > > g_beaker group - - i=1 > beaker onsoctcp beaker sql_turbo g=g_beaker > > /etc/hosts.equiv on gonzo > > beaker informix > > While on beaker I am able to define beaker fine using > cdr define server -- init g_beaker > > But when I try to define gonzo from beaker using > cdr define server -connect gonzo -init -sync g_beaker g_gonzo > > I receive this error message > command failed -- invalid server (47) > > %finderr 47 > > -47 Address family not supported by protocol family. > > An operating-system error code with the meaning shown was unexpectedly > returned to the database server. If the error recurs, please note all > circumstances and contact Informix Technical Support. > > Thanks for any help anyone may offer. > > Andrew Ford > Informix Database Administrator > Simplified Telesys > 5000 Plaza on the Lake > Suite 170 > Austin, TX 78746 > United States > > (512) 425-9767
Andrew Ford wrote: > > I am trying to set up replication and I am getting some errors that I don't know about. Has anyone run across this problem, and if so can you offer some advice? > > server 1 - beaker > SCO_SV > IDS Ver 7.30.UC2 > > $INFORMIXDIR/etc/sqlhosts > > g_beaker group - - i=1 > beaker_shm olipcshm beaker srv_agent g=g_beaker > beaker oltlitcp beaker sql_turbo g=g_beaker > > g_gonzo group - - i=2 > gonzo oltlitcp gonzo sql_turbo g=g_gonzo > > server 2 - gonzo > HP-UX 11 > IDS Ver. 7.30.UC7 > > $INFORMIXDIR/etc/sqlhosts > > g_gonzo group - - i=2 > gonzo_shm onipcshm gonzo srv_agent g=g_gonzo > gonzo onsoctcp *gonzo sql_turbo g=g_gonzo Why the asterix, is this your problem?