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

Table 12 DB2 Package Files (continued)
DescriptionFile Name
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 start it up.
cmapplyconf -P pkg.conf
cmmodpkg -e -n <node1> —n <node2> db2_payroll
cmmodpkg —e db2_payroll
For more information, see Managing ServiceGuard manual available at http://www.hp.com/go/
hpux-serviceguard-docs —>HP Serviceguard .
Database Maintenance
Sometimes, when the DB2 database has to be taken down for maintenance purposes like changing
configuration, without having the instance to migrate to standby node. The following procedure
should be used:
NOTE: The example assumes that the package name is db2_payroll, package directory is/etc/
cmcluster/pkg/db2_pkg.
• 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, as shown below:
$ touch /etc/cmcluster/pkg/db2_pkg/db2.debug
The toolkit monitor script (database instances) that continuously monitosr DB2 partitions would
now stop monitoring these partitions.
The message, "DB2 toolkit pausing, monitoring, and entering maintenance mode", appears
in the Serviceguard Package Control script log in case of legacy packages and package
configuration log file in case of modular style of packaging.
• If required, stop the DB2 database instance as shown below:
$ cd /etc/cmcluster/pkg/db2_pkg/
$ $PWD/toolkit.sh stop
• Perform maintenance actions (For example, changing the configuration parameters in the
parameter file of the DB2 instance. If this file is changed, remember to distribute the new file
to all cluster nodes).
• Start the DB2 database instance again if you have stopped it:
$ cd /etc/cmcluster/pkg/db2_pkg/
$ $PWD/toolkit.sh start
• Enable monitoring scripts to continue monitoring by removing db2.debug file:
$ rm -f /etc/cmcluster/pkg/db2_pkg/db2.debug
Adding the Package to the Cluster 85