HDR questions
Posted in 2008
Topics: High Availability & Replication, Connectivity: ODBC / JDBC / .NET
Couple of questions on HDR for the wise. We are at the testing stage of an ODBC-based application and want to test failover. HDR was working fine until I shut down both the instances and set DRAUTO to 1 on both sides; now the primary and secondary just say they can't find one another. I can connect across the instances fine in client-server. Any pointers? The standard DR error message is less than instructive. Next question: client failover using DBPATH. Our testing guy reckons the only way to switch servers is to manually alter the IPS address and INFORMIXSERVER in the ODBC config. He's convinced the DBPATH method won't work over ODBC. I reckon this is B.S. but I haven't touched ODBC for so long I don't know how to refute him. (Surely you just somehow switch between multiple connections?) What's the ODBC-based approach? Many thanks Andy
ANDY KENT said: > Couple of questions on HDR for the wise. > > We are at the testing stage of an ODBC-based application and want to test > failover. > > HDR was working fine until I shut down both the instances and set DRAUTO > to 1 > on both sides; now the primary and secondary just say they can't find one > another. I can connect across the instances fine in client-server. Any > pointers? The standard DR error message is less than instructive. > > Next question: client failover using DBPATH. Our testing guy reckons the > only > way to switch servers is to manually alter the IPS address and > INFORMIXSERVER > in the ODBC config. He's convinced the DBPATH method won't work over ODBC. > I > reckon this is B.S. but I haven't touched ODBC for so long I don't know > how to > refute him. (Surely you just somehow switch between multiple connections?) > What's the ODBC-based approach? Product versions? Platforms? http://publib.boulder.ibm.com/infocenter/idshelp/v111/topic/com.ibm.admin.doc/ad min602.htm?resultof=%22%68%64%72%22%20%22%67%72%6f%75%70%73%22%20%22%67%72%6f%75 %70%22%20 -- Bye now, Obnoxio "There were a myriad of problems which conspired to corrupt your reason and rob you of your common sense. Fear got the best of you, and in your panic you turned to the Labour Party. They promised you order, they promised you peace, and all they demanded in return was your silent, obedient consent." -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.
10.0 on Redhat 4.6.