Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2009

    Unanswered: DB2 FailOver - Switch Over

    Hi All,

    Our product makes use of DB2 database for auditing, we want to configure failover for main audit DB in case of a disaster.

    Can DB2 experts help me to choose a best way to achieve this? is it possible to set replication between main Audit db and a slave DB and switch to slave in case of a disaster ? if it is possible can you please provide me the links which explain this strategy?

    Thanks in advance,


  2. #2
    Join Date
    Jun 2003
    Toronto, Canada
    Provided Answers: 1
    Unless you need to access the slave database at the same time as the master, replication would not be the best approach for you. A standby database using HADR will be sufficient. Search the manual for HADR.

  3. #3
    Join Date
    Feb 2009

    Thanks for replying, can you please let me know whther the switch over occurs automatically in case of a crash such that client have not to be worried about availability of a server?

    Please explain.

  4. #4
    Join Date
    Aug 2010
    the automatical failover can be achived by TSA, which is integrated with db2 v95 and v97. That's also part of DB2 HA feature.

Posting Permissions

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