Re: Taking care of Fail Back in HDR

On Thu, 14 Aug 2003 04:41:22 -0400, Jack A wrote: You're welcome. Used to do it as described in the manuals (and you're right it's a pain) then we discovered that the version of iClient we were using was broken and would not failover using DBPATH (apparently someone with too much time on their hands had decided DBPATH was only used by SE so us IDS users did not need it anymore). The upgrade was several months away so we began to play. One of my DBAs suggested trying the ER failover group definitions and Eureka! It works! Art S. Kagel > Thanks. I couldnt believe the stuff i was reading in the manuals. > > "Art S. Kagel" <kagel@bloomberg.net> wrote in message > news:pan.2003.08.13.17.10.04.261687.15473@bloomberg.net... >> On Wed, 13 Aug 2003 08:36:49 -0400, Jack A wrote: >> >> OH! Forgot to mention. You would set INFORMIXSERVER or the >> '@servername' clause in a CONNECT TO statement to point to the group >> rather than one of the replicants. >> >> Art S. Kagel >> >> >> > Again this is another surprise for me in Informix that failover is >> > not automatic. In fact they expect the application logic to be >> > written keeping replication in mind. How crappy is that ? >> > >> > For all the guys that use HDR how do you take care of the primary >> > going down ? The manual mentioned 3 methods : >> > >> > Using DBPATH >> > Changing Connectivity information >> > Using INFORMIXSERVER. >> > >> > Which one is the preferred method ?