Oninit cdi / Archive
Talk to an expert →

hdr groups with ER

Posted in 2004

Topics: High Availability & Replication, Networking & sqlhosts Configuration, Platform-Specific Issues, Versions, Editions & End-of-Life

BobR — — source: IIUG Forums & Mailing Lists

.. don't think my last post made it. I have a serverA as a primary (HDR) to serverB. I have a 'shm' DBSERVERNAME and two DBSERVERALIASES: serverAtcp and serverAtcpR. The serverAtcpR service talks across a separate subnet just for the HDR. I now need to add ER to replicate a batch of tables from serverA -> serverC (and eventually serverA -> serverD). Since I am supposed to put serverA and serverB in the same group per the documentation, which services do I use? serverAtcp and serverBtcp, serverAtcpR and serverBtcpR, all four?? Also, the docs say to change my environment $INFORMIXSERVER to the 'tcp' connection. Which one; serverAtcp or serverAtcpR? If I use serverAtcpR, then all utilities or monitoring programs using $INFORMIXSERVER will be "impacting" my ER/HDR connection. RH Linux Enterprise AS, IDS 9.40.UC2 Thanks for any help! /bobr/

↪ replying to BobR
Colin Bull — — source: IIUG Forums & Mailing Lists

BobR wrote > > I have a serverA as a primary (HDR) to serverB. I have a > 'shm' DBSERVERNAME and two DBSERVERALIASES: serverAtcp and > serverAtcpR. The serverAtcpR service talks across a separate > subnet just for the HDR. > > I now need to add ER to replicate a batch of tables from > serverA -> serverC (and eventually serverA -> serverD). > Since I am supposed to put serverA and serverB in the same > group per the documentation, which services do I use? > serverAtcp and serverBtcp, serverAtcpR and serverBtcpR, all four?? > > Also, the docs say to change my environment $INFORMIXSERVER > to the 'tcp' connection. Which one; serverAtcp or > serverAtcpR? If I use serverAtcpR, then all utilities or > monitoring programs using $INFORMIXSERVER will be "impacting" > my ER/HDR connection. g_hdr group - - i=1, e=ServerBtcp ServerAtcp onsoctcp ServerA sqlexec g=g_hdr ServerBtcp onsoctcp ServerB sqlexec g=g_hdr This is my guess at what you need. As long as the subnet between ServerA and ServerB is set up, this should be OK, and service should fail over to the secondary. Best to test of course! Colin B ________________________________________________________________________ This email has been scanned for all known viruses by the MessageLabs Email Security System. ________________________________________________________________________

Glossary