Re: HDR over secondary network

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. >