Introduction
In this paper, we describe how to automate IBM® DB2® Universal Database™ High Availability Disaster Recovery Option takeover in a High-Availability Cluster Multi-Processing (HACMP™) environment. We also describe the failover test procedure for HADR controlled by the HACMP facility.
DB2 HADR - DB2 HADR is a data replication feature that provides a high-availability solution for both partial and complete site failures. DB2 HADR is designed for quick failover, easy setup, and manageability. HADR protects against data loss by replicating data changes from a source database, called the primary, to a target database, called the standby. It is an example of database log shipping technology; transactions that occur on the primary database are also applied to a designated standby database so that if the primary database becomes inaccessible, clients can continue using the standby database. The logic to perform the state change can be embedded within a high-availability cluster manager to provide unattended HADR failover.
HACMP - HACMP for AIX® provides a highly available computing environment. This facilitates the automatic switching of users, applications, and data from one system to another in the cluster after a hardware or software failure. The primary reason to create HACMP clusters is to provide a highly available environment for mission-critical applications. For example, an HACMP cluster could run a database server program that services client applications. The clients send queries to the server program that responds to their requests by accessing a database that is stored on a shared external disk.
In an HACMP cluster, to ensure the availability of these applications, the applications are put under HACMP control. HACMP takes measures to ensure that the applications remain available to client processes even if a component in a cluster fails. To ensure availability, in case of a component failure, the HACMP software moves the application, along with resources that ensure access to the application, to another node in the cluster.
Download the full report for more on IBM DB2 UDB HADR with HACMP.
Download the report to get started!
#Db2