Welcome to the Db2 HADR Wiki

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

• Introduction

  • 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

• Tutorials and General Info

  • HADR Tutorial General tutorial focusing on the base case (single standby, non-pureScale)

  • HADR Frequently Asked Questions (FAQ)

  • 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

• HADR Tool Box

  • Step by Step Guide to configure TCP and HADR sync mode for optimal performance.

  • HADR Simulator simulates HADR workload on the network and disk.

  • Db2 Log Scanner scans log files to analyze workload.

• HADR Configuration and Tuning

  • HADR Configuration

  • HADR sync mode

  • TCP Tuning

• Specific Topics

  • 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

• Automated Failover and Client Reroute

  • Automating HADR failover , how to use HADR with cluster managers

  • Client Reroute , Automatic Client Reroute (ACR) and other reroute methods

• Performance and Diagnostics

  • HADR Performance Tuning and Diagnostics

  • HADR primary and standby cannot connect to each other

  • db2diag.log What to look for in db2diag.log for HADR.