Beginning in DB2 LUW version 10.1, the high availability disaster recovery (HADR) feature supports up to three standby databases, allowing you to provide both high availability (HA) and disaster recovery (DR) protection to a database with a single technology. This paper shows how HADR multiple standbys can be set up, configured, and monitored. Through various examples, you will also learn how HADR multiple standby behaves in different failure scenarios, and how you can utilize multiple standbys with other HADR features.

Bruce Jackson (, Software Developer, IBM China

Bruce Jackson author photoBruce Jackson has worked in enterprise software development with Informix Software and IBM since 1999. He has worked on the design and development of multiple high availability products in IBM, including clustered SAN file systems, DB2 pureScale, HACMP, and DB2 HADR. He has also worked on standards based open systems storage management solutions.

Dale McInnis (, Senior Technical Staff Member (STSM), IBM  

Dale McInnis author photoDale McInnis is a Senior Technical Staff Member (STSM) at the IBM Toronto Canada lab. He has a B.Sc.(CS) from the University of New Brunswick and a Masters of Engineering from the University of Toronto. Dale joined IBM in 1988, and has been working on the DB2 development team since 1992. Dale's area of expertise includes DB2 for LUW Kernel development, where he led teams that designed the current backup and recovery architecture and other key high availability and disaster recovery technologies. Dale is a popular speaker at the International DB2 Users Groups (IDUG) conferences worldwide, as well as DB2 Regional users groups and IBM's Information On Demand (IOD) conference. His expertise in the area DB2 availability area is well known in the information technology industry. Dale currently fills the role of DB2 Availability Architect at the IBM Toronto Canada Lab.

Effi Ofer (, Software Developer, IBM China

Effi Ofer author photoEffi Ofer has played key roles in the development of DB2 in areas ranging from monitoring to recovery to indexing and concurrency. Most recently he led the multiple standby team.

Nailah Bissoon (, Performance Technical Team Lead, IBM

Nailah Ogeer Bissoon author photoNailah Ogeer Bissoon is currently a performance technical team lead for the DB2 performance quality assurance team. Nailah joined the IBM Toronto Lab in 2004 and has worked on several DB2 performance benchmark publications and used this skill set to diagnose and fix performance related problems in the field. Ensuring that DB2 remains as one of the top performers among DBMSs is vital to her role.

Punit Shah (, Software Engineer, IBM

Author photo: Punit ShahPunit Shah has extensive experience in database architecture, workload optimization, performance and system virtualization. He has written extensively on variety of technology topics. He has been a member of DB2 recovery development team and recently contributed to the shared disk backup and recovery solution in DB2 Version 9.8 and the HADR development for future releases.

Roger Zheng (, Software Developer, IBM China

Roger Zheng author photoRoger Zheng is a master innovator and a world authority on the design and implementation of logging, locking, recovery and transaction management algorithms. Roger currently provides leadership to a number of DB2 Kernel teams, including HADR.

Vincent Kulandai Samy (, Software Developer, IBM China

Photo of author VincentVincent Kulandai Samy is a DB2 kernel developer in IBM Beaverton Lab, working on DB2 for Linux, UNIX, and Windows kernel development for the past 10 years. He came to IBM as part of Informix acquisition. Prior to the Informix acquisition, he was working on Informix IDS and XPS database kernel. His areas of expertise are database kernel, DB2 HADR, Multi-Temperature Warehouse, recovery, backup and restore, Linux kernel internals and kernel debugging. He was the technical lead for DB2 HADR Reads on Standby feature, released in DB2 Version 97 Fix Pack 1. For the past three years, Vincent has also been championing several DB2 HADR adoptions and new sale/deployments through on-site customer visits, consultancy, customer advocacy. He had presented DB2 HADR/TSA customer success stories at IOD conferences with Fidelity Investments and PepsiCo in 2008 and 2010.

Yuke Zhuge (, Software Developer, IBM China

Yuke Zhuge author photoYuke Zhuge has been in the database industry for more than 15 years. He worked at Informix Software from 1995 to 2000. He has been working at IBM since 2000. He was one of the initial creators of DB2 HADR and has been the HADR component owner since its initial release. He is now leading the HADR team to add more exciting features.

21 June 2012

The multiple standby HADR feature provides database administrators (DBAs) with a single technology to provide both high availability (HA) as well as disaster recovery (DR). This paper shows how HADR multiple standbys can be set up, configured, and monitored. In addition, various examples demonstrate how HADR multiple standby behaves in different failure scenarios.

In this white paper

  • Business value of HADR
  • Introduction
  • Planning for multiple standbys
  • Configuring multiple standbys
  • Setting up multiple standbys
  • Adding and dropping standby targets
  • Takeover
  • Automation
  • Log archiving considerations
  • Reads on standby
  • Rolling upgrade
  • Log spooling
  • Delayed log replay on standby
  • NAT - Network Address Translation
  • Monitoring
  • Multiple standby performance
  • Conclusion
  • Acknowledgements
  • Resources
  • About the authors


White paper in PDF formatHADR_Multiple_Standbys_jn20.pdf654 KB


Zone=Information Management
SummaryTitle=DB2 10.1 HADR Multiple Standbys