Results 1 to 5 of 5

Thread: HADR suggestion

  1. #1
    Join Date
    Jul 2009
    Location
    USA
    Posts
    53

    Unanswered: HADR suggestion

    We're using DB2 9.5 on AIX and are looking at implementing HADR. HADR doesn't perform automatic failover so we need to use HACMP or TSA to automate it? Any suggestion which one to use? Are there any other options to automate the failover?
    Last edited by db2aix; 09-02-09 at 21:13.

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Veritas Cluster Manager makes a product that has an HADR agent. I have not personally used it, but looked at it about 3 years ago. TSA was not very good at the time, but has improved greatly since then in terms of HADR integration. My company uses Red Hat Cluster Manager (decision of the system admins).
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Jul 2009
    Location
    USA
    Posts
    53
    Can HADR be used by itself? I mean do we really need to use some cluster software such as HACMP? If we don't use it, how do we detect primary is down and when to switch over to standby?

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    You can use HADR without a cluster manager. If you write your own scripts to monitor the databases you could issue the takeover command yourself. But in that case you have just written your own cluster manager (not that there is anything wrong with that). It would be best if the monitoring was done from a third server IMO.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  5. #5
    Join Date
    Jul 2009
    Location
    USA
    Posts
    53
    This is exactly what I wanted to know

Posting Permissions

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