Results 1 to 3 of 3

Thread: HADR question.

  1. #1
    Join Date
    Mar 2005

    Unanswered: HADR question.

    db2 V9.1 FP5
    AIX 5.3

    can we automatically do a failover of HADR .
    I know HADR is manula. But by using a third party software can we do a automatic failover .

    Or the ONly option is using HACMP.

  2. #2
    Join Date
    Jan 2008
    There are other products also like Tivoli System Automation (TSA) and Veritas Cluster Server (VCS) which works on AIX. I haven't used any of the two. I have only used HACMP.

  3. #3
    Join Date
    May 2003
    Tivoli System Automation comes free with DB2, but I found it difficult to use. although the last version we used was 2.1 and improvements have been made since then.

    Currently we use Red Hat Cluster Suite, but someone has to write scripts to trigger an HADR takeover if the Cluster software detects a problem (such as server down). We are using a VIP for the database IP address that the Cluster Suite switches over in addition to doing an HADR takeover. Obviously, RH Cluster Suite will not work with AIX.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts