Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Bay Area, CA

    Question Unanswered: DB2/UDB 8.1 HA Failover


    I am doing some preliminary research on HA failover capabilities on DB2/UDB 8.1. The docs are a little light on details so I thought I'd ask this forum ...

    Let say I have a two node cluster (NodeA and NodeB) with each node running its own instance of DB2/UDB (InstanceA and InstanceB) servicing completely different databases and applications. I understand one supported configuration is a "mutual failover" where each node monitors the other and fails over under the right fault conditions.

    My question is ... When the NodeA fails, does the original instanceB on NodeB simply "mount" InstanceA's databases and run rollforward recovery on its logs. In other words, when failover occurs, must an entire startup of DB2 occur (including all the costs associated with it such as allocating memory, setting up buffer pools, etc ...)?

    Perhaps it depends on the HA software used (HACMP vs Veritas, etc.), but I imagine DB2/UDB needs some capabilities to support failover to an already running instance.

    Thanks in advance

  2. #2
    Join Date
    Jun 2003
    I don't known other HA that HACMP and the aswer to "In other words, when failover occurs, must an entire startup of DB2 occur" is yes.


Posting Permissions

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