With the high availability (HA) feature of IBM® DB2® 9.7, a DBA can set up redundant systems and a failover mechanism, thereby improving the availability of the database. A two-node shared disk HA topology contains an active node to host the DB2 instance and data, and a possive node, where the DB2 resources move in the event of failure. In this article, the authors present and work through two examples showing how to use db2haicu to configure high availability with a shared disk topology.
In this article
- Overview of HA concepts
- Setting up an automated HA topologyu for an instance with no databases
- Setting up an automated HA topology with pre-existing databases
- Post configuration testing
- Other configurations
- Problem determination
This article describes a distinct configuration of an automated DB2 for Linux® and UNIX® software failover solution that uses shared disk storage. The configuration is based on the DB2 high availability (HA) feature and the DB2 High Availability Instance Configuration Utility (db2haicu) available with the DB2 Version 9.7 software release.
With the High Availability (HA) feature of DB2 9.7, a database administrator (DBA) can set up redundant systems and a failover mechanism, thereby improving the availability of the database solution. In the event of an unplanned or planned outage, the instance fails over to the available redundant systems. The db2haicu tool can be used to configure such an HA system. During the db2haicu configuration process, the necessary HA resources and their relationships are defined to the cluster manager. Failure events in the HA system can then be detected automatically, and takeover operations can be run without manual intervention.
A two-node shared disk HA topology contains an active node to host the DB2 instance and data, and a passive node to which DB2 resources move in case of a failure event. For this topology, the two nodes are connected to each other over a single public network and wired to a shared disk storage system. The term shared storage describes a system in which one or more disks are cabled and defined to both the active and passive nodes but only mounted at one node at a time, that is, the node that hosts the active DB2 instance. At any given time, only one node has exclusive access to the shared storage disks. That is, only one node can effectively do input/output (I/O) to shared storage disks.
This article presents two primary examples. In the first example, we use the db2haicu interactive mode to automate a single network shared disk HA topology with no pre-existing databases. This example demonstrates how the creation of database objects add mount point resources to the cluster, and conversely, how the removal of databases objects remove mount point resources from the cluster.
In the second example, we configure a single network HA topology, automated using the db2haicu XML mode for DB2 instance with pre-existing databases. This shows how db2haicu can automatically discover mount points for pre-existing databases and create the appropriate cluster resources.
|Article in PDF format||DB2v97HASharedStorage.pdf||1.07MB|
- In the DB2 for Linux, UNIX, and Windows area on developerWorks, get the resources you need to advance your skills in DB2.
- Find information describing how to use DB2 in the DB2 for Linux, UNIX, and Windows Information Center.
- Browse the technology bookstore for books on these and other technical topics.
Get products and technologies
- Download DB2 Express-C 9.7, a no-charge version of DB2 Express database server for the community.
- Download a free trial version of DB2 9.7 for Linux, UNIX, and Windows..
- Download IBM product evaluation versions or explore the online trials in the IBM SOA Sandbox and get your hands on application development tools and middleware products from DB2>, Lotus®, Rational®, Tivoli, and WebSphere®.