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
>