Configuring a clustered environment for high availability

Creating a cluster of machines, and using cluster managing software to balance work load on those machines is one strategy for designing a highly available solution. If you install IBM® Db2® server on one or several of the machines in a cluster, you must configure the cluster manager to properly react to failures that affect the database or databases. Also, you must configure the database manager instances to work properly in the clustered environment.

About this task

Configuring and administering the database instances and the cluster manager manually is complex, time consuming, and prone to error. The Db2 High Availability Feature provides infrastructure for enabling the database manager to communicate with your cluster manager when instance configuration changes, such as stopping a database manager instance, require cluster changes.

There are two cluster manager products for implementing High Availability solution:

Pacemaker: This cluster manager is used for Db2 on Linux. Please follow Configuring high availability with the Db2 cluster manager utility (db2cm) to configure your chosen High Availability solution on Linux.
Tivoli SA MP: This cluster manager is used for Db2 on AIX. The task described below is specific to using Tivoli SA MP-managed Db2 instance on AIX.

Note: If you are using an AIX® system, consider enabling the system error log (syslog) to capture relevant messages from Tivoli®SA MP and RSCT subsystems and from the Db2 automation scripts. For more information, see the Related links.

Procedure

Install cluster managing software.

Tivoli SA MP is integrated with Db2 Enterprise Server Edition, Db2 Advanced Enterprise Server Edition, Db2 Workgroup Server Edition, Db2 Connect Enterprise Edition, and Db2 Connect Application Server Edition on AIX operating systems.
Configure Db2 database manager instances for your cluster manager, and configure your cluster manager for Db2 server.

Db2 high availability instance configuration utility (db2haicu) is a text-based utility that you can use to configure and administer your highly available databases in a clustered environment.
Over time, as your database needs change and you need to modify your database configuration within the clustered environment, continue to keep the database manager instance configuration and the cluster manager configuration synchronized.