Re: HDR over secondary network
MMarks set up HDR with a separate sync network, and it worked only when srvB had just the sync connection; with both NICs he had to use the standard-network names. Ajaykg68 suggested checking trusted informix accounts (error -956). Andreas Legner noted the sqlhosts entries did not match. Art Kagel said shared-memory names cannot be used for HDR; use a TCP alias.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
On Thu, 22 Dec 2005 17:55:56 -0500, "Art S. Kagel"
<kagel@bloomberg.net> wrote:
>MMarks wrote:
>
>OK, post the sqlhosts entries for the two servers and the exact onmode
>command you are trying to use to initiate HDR.
>
on srvA:
srvA onipcshm srvA srvA
srvB onsoctcp srvB-sync istarcars
(istarcars is the name of the service we use for remote DB
connections)
command: onmode -d primary srvB
on srvB
srvB onipcshm srvB srvB
srvA onsoctcp srvA-sync istarcars
command: onmode -d secondary srvA
This works fine if srvB only has a network connection to the sync
network.
If srvA has NIC cards on both sync and the standard network, I have to
change the "srv?-sync" parts of the sql hosts file to the standard
name, then it will work over the standard network only.
Verify if you have trusted informix account on two machines when sync
network is use.
If you see the following message in online.log of paried server, the
two machines does not have tursted informix account:
08:30:18 listener-thread: err = -956: oserr = 0: errstr =srvA-sync.com: Client host or user informix@srvA-sync.com is not
trusted by the server.
Hmmm ... if two networks are used, srvB and srvB-sync would resolve to different ip addresses,
similar would be true for srvA and srvA-sync, wouldn't it?
So is srvA (DBSERVER...) listening on srvA or on srvA-sync now?
In other words: the two sqlhosts files' informations don't seem to match.
HTH,
Andreas
MMarks wrote:
> On Thu, 22 Dec 2005 17:55:56 -0500, "Art S. Kagel"
> <kagel@bloomberg.net> wrote:
>
>
>>MMarks wrote:
>
>
>>OK, post the sqlhosts entries for the two servers and the exact onmode
>>command you are trying to use to initiate HDR.
>>
>
>
> on srvA:
>
> srvA onipcshm srvA srvA
> srvB onsoctcp srvB-sync istarcars>
> (istarcars is the name of the service we use for remote DB
> connections)
>
> command: onmode -d primary srvB
>
> on srvB
>
> srvB onipcshm srvB srvB
> srvA onsoctcp srvA-sync istarcars>
> command: onmode -d secondary srvA
>
> This works fine if srvB only has a network connection to the sync
> network.
> If srvA has NIC cards on both sync and the standard network, I have to
> change the "srv?-sync" parts of the sql hosts file to the standard
> name, then it will work over the standard network only.
>
MMarks wrote:
> On Thu, 22 Dec 2005 17:55:56 -0500, "Art S. Kagel"
> <kagel@bloomberg.net> wrote:
>
>
>>MMarks wrote:
>
>
>>OK, post the sqlhosts entries for the two servers and the exact onmode
>>command you are trying to use to initiate HDR.
>>
>
>
> on srvA:
>
> srvA onipcshm srvA srvA
> srvB onsoctcp srvB-sync istarcars>
> (istarcars is the name of the service we use for remote DB
> connections)
>
> command: onmode -d primary srvB
>
> on srvB
>
> srvB onipcshm srvB srvB
> srvA onsoctcp srvA-sync istarcars>
> command: onmode -d secondary srvA
You cannot use srvA here or srvB in the onmode above because srvA & srvB are
shared memory connectsion which cannot be used to communicate between
different machines nor between multiple instances on the same machine. You
MUST use a tcp/ip or other supported network connection alias.
Art S. Kagel
> This works fine if srvB only has a network connection to the sync
> network.
> If srvA has NIC cards on both sync and the standard network, I have to
> change the "srv?-sync" parts of the sql hosts file to the standard
> name, then it will work over the standard network only.
>