CDR questions

Hi people !! I have 2 questions about ER in Informix 9.40: 1 - I am testing ER in a same host, using Linux and Informix 9.40, but I am receiving the followin error during the cdr define server: (I was using: cdr define server --init --ats=/tmp/ats --ris=/tmp/ris <group name>) "server not defined in sqlhosts (35) in online.log: CDR Error: group (group name) ER will not be able to find a TCP connection. Check network configuration. But the configuration is ok... I can connect both instances when I use dbaccess - connection - connect. I can connect the group and the server in both sides of my instances. What is wrong in this case ? 2 - I need to configure a ER with 2 AIX machines, but the primary server must be Informix 9.40 and the secondary server or slave must be Informix 7.31. Can I do this kind of configuration ? If I can, there is some manual to explain how can I do this ? Tks, Eduardo

cboccio@yahoo.com.br wrote: > Hi people !! > > I have 2 questions about ER in Informix 9.40: > > 1 - I am testing ER in a same host, using Linux and Informix 9.40, but > I am receiving the followin error during the cdr define server: (I was > using: cdr define server --init --ats=/tmp/ats --ris=/tmp/ris <group > name>) > "server not defined in sqlhosts (35) > in online.log: > CDR Error: group (group name) > ER will not be able to find a TCP connection. Check network > configuration. > > But the configuration is ok... I can connect both instances when I use > dbaccess - connection - connect. I can connect the group and the server > in both sides of my instances. > > What is wrong in this case ? Without seeing the exact statement and the sqlhosts file, I can't tell. > > 2 - I need to configure a ER with 2 AIX machines, but the primary > server must be Informix 9.40 and the secondary server or slave must be > Informix 7.31. > Can I do this kind of configuration ? If I can, there is some manual > to explain how can I do this ? Yes - ER supports 9.40 <---> 7.31. there is nothing special about doing this so there isn't a seperate manual for it. You will need to set CDRSITES, which is described in the 9.40 installation guide. > > Tks, > > Eduardo

mpruet@comcast.net wrote: > cboccio@yahoo.com.br wrote: >> Hi people !! >> >> I have 2 questions about ER in Informix 9.40: >> >> 1 - I am testing ER in a same host, using Linux and Informix 9.40, but >> I am receiving the followin error during the cdr define server: (I was >> using: cdr define server --init --ats=/tmp/ats --ris=/tmp/ris <group >> name>) >> "server not defined in sqlhosts (35) >> in online.log: >> CDR Error: group (group name) >> ER will not be able to find a TCP connection. Check network >> configuration. >> Post the following information : 1. sqlhosts for both servers 2. DBSERVERNAME and DBSERVERALIAS for both servers Make sure that the TCP connection is used as the DBSERVERNAME Make sure that you can connect using the tcp DBSERVERNAME from instance 1 to instance 2 and instance 2 to instance 1 >> But the configuration is ok... I can connect both instances when I use >> dbaccess - connection - connect. I can connect the group and the server >> in both sides of my instances. >> >> What is wrong in this case ? > > Without seeing the exact statement and the sqlhosts file, I can't tell. > >> 2 - I need to configure a ER with 2 AIX machines, but the primary >> server must be Informix 9.40 and the secondary server or slave must be >> Informix 7.31. >> Can I do this kind of configuration ? If I can, there is some manual >> to explain how can I do this ? > > Yes - ER supports 9.40 <---> 7.31. there is nothing special about > doing this so there isn't a seperate manual for it. You will need to > set CDRSITES, which is described in the 9.40 installation guide. > >> Tks, >> >> Eduardo >