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.
- Business value of HADR
- Planning for multiple standbys
- Configuring multiple standbys
- Setting up multiple standbys
- Adding and dropping standby targets
- Log archiving considerations
- Reads on standby
- Rolling upgrade
- Log spooling
- Delayed log replay on standby
- NAT - Network Address Translation
- Multiple standby performance
- About the authors
|White paper in PDF format||HADR_Multiple_Standbys_jn20.pdf||654 KB||HTTP|
- Learn more about Automated Cluster Controlled HADR (High Availability Disaster
Recovery) Configuration Setup using the IBM DB2 High Availability Instance
Configuration Utility (db2haicu).
- Visit the DB2 Version 10.1 for Linux,
UNIX, and Windows Information Center to learn more about configuring a clustered
environment using DB2 High Availability Instance Configuration Utility
- Learn more about the HADR simulator to help you estimate HADR performance without starting a
- Follow developerWorks on
- Watch developerWorks on-demand demos advanced functionality for
Get products and technologies
products in the way that suits you best: Download a product trial,
try a product online, use a product in a cloud environment, or spend a few
hours in the SOA Sandbox learning how to implement Service Oriented
- Participate in the discussion forum.
- Get involved in the My developerWorks
community. Connect with other developerWorks users while exploring
the developer-driven blogs, forums, groups, and wikis.
Bruce 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 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.
Nailah 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 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 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 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 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.