HP Enterprise Cluster Master Toolkit User Guide (5900-2131, December 2011)

4 Using the DB2 database Toolkit in a Serviceguard Cluster
in HP-UX
DB2 is a RDBMS product from IBM. This chapter describes the High Availability toolkit for DB2
V9.1, V9.5 and V9.7 designed to be used in a Serviceguard environment. This chapter covers
the basic steps to configure DB2 instances in a Serviceguard cluster. For more information on
support matrix, see compatibility matrix available at http://www.hp.com/go/
hpux-serviceguard-docs —>HP Serviceguard .
This chapter assumes that the readers are already familiar with Serviceguard configuration, as
well as with DB2 database server concepts, including installation and configuration procedures.
NOTE: This toolkit runs on 11i v2 and 11i v3 HP-UX distributions. This toolkit is not supported
on 11i v1 HP-UX distribution and it is supported in all hardware supported by the Serviceguard.
Database Partitioning Feature (DPF) is supported only with the following versions:
• DB2 V9.1.
• DB2 V9.7 with Fix Pack 2.
The DB2 Database Toolkit for Serviceguard consists of a set of shell scripts that are used to start,
stop, and monitor the DB2 database instances. This toolkit can be used with the legacy and modular
style Serviceguard packages. It is strongly recommended to use the modular style of packaging
as the legacy style of packaging will be obsolete in future. Subsequent sections of this chapter
provide guidelines for integrating this toolkit with the Serviceguard package control script (for
legacy packages), or with the master control script (for modular packages). The DB2 Database
Toolkit for Serviceguard can also be configured using the Serviceguard manager graphical user
interface.
NOTE: This chapter assumes that the user has already installed Serviceguard, a DB2 Database,
and the Enterprise Cluster Master toolkit version B.06.00 on all cluster nodes.
DB2 Information
Each cluster member requires a local copy of DB2 server. DB2 instances are configured as packages
under Serviceguard. Clients connect to the DB2 database using an IP address that is assigned to
the Serviceguard package. Serviceguard monitors the health of the DB2 Database Server using
the DB2 Database utility tool "db2gcf". In case of a failure of DB2 system on one node, Serviceguard
fails over all the necessary resources and starts up an identical DB2 instance on one of the standby
nodes.
Setting Up the Application
The steps below outline the installation procedures and the necessary checks required to provide
high availability for DB2 UDB Enterprise Server Edition V9.5 /V9.7 in Serviceguard. For additional
details see Quick Beginning for DB2 Servers available at ftp://ftp.software.ibm.com/ps/products/
db2/info/vr95/pdf/en_US/db2ise952.pdf.
1. Create a volume group, a logical volume, and a file system to hold the database. The volume
group, logical volume and file system parameters have to be defined in the Serviceguard
package configuration file. Since the volume group and file system must be uniquely named
within the cluster, include the identity of the database instance in their names. For step-by-step
instructions on creating a volume group, see chapter Building an HA Cluster Configuration in
DB2 Information 71