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