HADR (High Availability Disaster Recovery) is a Db2 LUW feature for high availability and disaster recovery. It is the preferred solution for HA and DR on Db2. It replicates data in real time from a primary database to one or more standby databases. In case the primary database fails, a standby database takes over as the new primary. Integrated cluster manager can be enabled for automated failover. Reads on standby can be enabled. Multiple standbys are supported since V10.1.
This site is maintained by the Db2 HADR development team. It is information directly from the lab. It is intended for HADR education, knowledge sharing, and product support. It provides valuable advices built up from years of development and support work. You can reach us at:
db2hadr@wwpdl.vnet.ibm.com
Site Map
Why use HADR? Benefits and feature highlight of HADR.
Feature history : List of new HADR features since original release in Db2 V8.2.
What's new: V10.5: pureScale support . V10.1: Multiple Standby . V97fp1: Reads on standby
HADR Tutorial General tutorial focusing on the base case (single standby, non-pureScale)
HADR multiple standby White paper. Comprehensive writing on multiple standby
HADR on pureScale Tutorial for HADR in pureScale environment.
HADR in IBM PureData System for Transactions White paper specifically for the PureData appliance.
Simplify Db2 HADR with IBM PureApplication System HADR is even easier on pureApplication systems.
HADR best practices Best Practice white paper.
Reads on Standby Reads on Standby tutorial
Step by Step Guide to configure TCP and HADR sync mode for optimal performance.
Db2 Log Scanner scans log files to analyze workload.
HADR commands , Start/stop/takeover HADR, role change, HADR database startup/shutdown
HADR monitoring What to look for in monitor output and db2diag.log.
HADR log shipping How does HADR ship logs? What are the HADR states?
HADR takeover : Role switch, failover, primary reintegration
Automating HADR failover , how to use HADR with cluster managers
Client Reroute , Automatic Client Reroute (ACR) and other reroute methods
db2diag.log What to look for in db2diag.log for HADR.