HP Serviceguard Enterprise Cluster Master Toolkit User Guide, December 2012 (5900-2145)

PARTITION_NUMBER[1]=1
MONITOR_PROCESSES[0]=db2sysc
MONITOR_PROCESSES[1]=db2acd
MAINTENANCE_FLAG=YES
MONITOR_INTERVAL=30
TIME_OUT=30
12. After setting up the Serviceguard environment, each clustered DB2 instance must have the
following files in the related package directory. For example, the DB2 package, located at
/etc/cmcluster/pkg/db2_pkg, must contain the following files list in Table 12.
Table 12 DB2 Package Files
DescriptionFile Name
Serviceguard package control script for legacy packaging style.$PKG.cntl
Serviceguard package configuration file.$PKG.conf
Main shell script of the toolkit.hadb2.sh
Monitor the health of the application.hadb2.mon
Toolkit DB2 configuration file.hadb2.conf
Interface between pkg.cntl and hadb2.sh.toolkit.sh
Adding the Package to the Cluster
After the setup is complete, add the package to the SG cluster, and then start it up.
cmapplyconf -P pkg.conf
cmmodpkg -e -n <node1> —n <node2> db2_payroll
cmmodpkg —e db2_payroll
For more information, see the latest Managing Serviceguard manual available at http://
www.hp.com/go/hpux-serviceguard-docs —>HP Serviceguard .
Database Maintenance
At regular intervals, the DB2 database needs maintenance like changing configuration, without
migrating the instance to standby node. The following procedure should be used:
NOTE: In the example, consider that the package name is db2_payroll, package directory
is/etc/cmcluster/pkg/db2_pkg.
Steps for Database maintenance:
• Disable the failover of the package through the cmmodpkg command:
$ cmmodpkg -d db2_payroll
• Pause the monitor script.
Create an empty file /etc/cmcluster/pkg/db2_pkg/db2.debug
$ touch /etc/cmcluster/pkg/db2_pkg/db2.debug
The toolkit monitor script (database instances) that continuously monitors DB2 partitions will
now stop monitoring these partitions.
The message, "DB2 toolkit pausing, monitoring, and entering maintenance mode", appears
in the Serviceguard Package Control script log for legacy packages and package configuration
log file in case of modular style of packaging.
• If required, stop the DB2 database instance:
Adding the Package to the Cluster 85