Automated cluster controlled HADR configuration setup using the IBM DB2 high availability instance configuration utility

Learn how to configure a failover solution for IBM® DB2® for Linux®, UNIX®, and Windows®, using the DB2 high availability disaster recovery (HADR) feature and the the DB2 high availability instance configuration utility (db2haicu). This article walks you through the concepts and then shows how to set up two distinct configurations for automated failover.

In this article

  • Overview of HADR and db2haicu concepts
  • Setting up an automated multiple network HADR topology
  • Setting up an automated single network HADR topology
  • Post-configuration testing
  • Maintenance
  • Setup for Multiple Standby HADR
  • Troubleshooting

Overview

Db2haicu is a tool available with DB2 10.1 for Linux, UNIX, and Windows, and stands for "DB2 high availability instance configuration utility." This utility takes in user input regarding the software and hardware environment of a DB2 instance, and configures the instance for high availability using the Tivoli® System Automation Cluster Manager.

The HADR feature of DB2 10.1 allows you to have one hot standby copy of any DB2 database such that, in the event of a primary database failure, a DBA can quickly switch over to the hot standby with minimal interruption to database clients. However, a HADR primary database does not automatically switch over to its standby database in the event of failure, but requires a DBA to manually perform the takeover operation.

The db2haicu tool can be used to automate such a HADR system. During the db2haicu configuration process, the necessary HADR resources and their relationships are defined to the cluster manager. Failure events in the HADR system can then be detected automatically and takeover operations can be executed without manual intervention.

New in DB2 10.1 is the HADR Multiple Standby feature. With this feature, you can now have up to three standby databases. One of these standbys is designated as the principal HADR standby. The db2haicu tool can be used to automate failover between the primary and principal standby HADR databases.


Downloadable resources


Related topics

static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management
ArticleID=421047
SummaryTitle=Automated cluster controlled HADR configuration setup using the IBM DB2 high availability instance configuration utility
publish-date=04132016