HP Serviceguard Toolkits for Database Replication Solutions Managing packages, Running packages

Page 42

Attributes	Description
	For DB2 HADR Service
service_name	Name of the service that Serviceguard monitors while
	the package is up. This name must be unique for both
	primary and standby packages in a Serviceguard
	cluster. The default value is db2hadr_service.
service_cmd	$SGCONF/scripts/tkit/db2hadr/
	tkit_module.sh db2hadr_monitor
service_restart	This attribute specifies the number of times the service
	was restarted before failing. The default value is [none].
service_fail_fast_enabled	This attribute enables Serviceguard to halt the node if
	the service fails on that node. The default value is set to
	[no].
service_halt_timeout	It is used to determine the duration for which
	Serviceguard waits for the service to halt before a
	SIGKILL signal. The default value is [300 seconds].

5.After the package configuration file is edited, save the file.

6.To validate the package configuration file, run the command: cmcheckconf –P pkg.conf

7.To apply the command if the cmcheckconf command succeeds, run the command: cmapplyconf -P pkg.conf

8.Confirm if you want to modify the package configuration. The default value is [yes]

9.To enable auto run and package failover, run the following commands, $ cmmodpkg -e-n <node1> -n <node2> hadrpkg

and, $ cmmodpkg -e hadrpkg

10.To verify that the package is created, run the cmviewcl command.

Managing packages

Running packages

To start the DB2 database and DB2 HADR, start the package using the following command:

# cmrunpkg <package_name>.

NOTE:

•The start command is the same for both primary and standby packages.

•You must start the standby package before starting the primary package. Otherwise, the primary package fails to start.

Maintaining packages

When packages are set to the maintenance mode, it handles the maintenance work on both DB2 database and DB2 HADR without bringing down the package.

Perform the following steps to work with the package maintenance mode:

42 Serviceguard toolkit for DB2 High Availability Disaster Recovery

Image 42

Contents HP Part Number Published August Edition Page Contents Glossary Index Introduction Overview AdvantagesSupported configuration DependenciesSingle-instance Oracle database Cmmakepkg -i pkgasciifile -m modulefilename outputfilename RAC environment RAC environmentServiceguard toolkit for Oracle Data Guard Data Guard replication between RAC primary and RAC standby Continentalclusters environment Continentalclusters environment Metrocluster and extended distance cluster environments Supported configuration Data Guard setup in an EDC environment Three data center configuration Configuring multiple instances of Oracle Data Guard Multiple Data Guard instances in each Serviceguard cluster# swinstall -s depot path Setting up Oracle Data Guard toolkitInstalling and uninstalling Oracle Data Guard toolkit High availability for data guard broker# swlist -l product T2259AA Files for the ADF module Activestandby Configuring Oracle Data Guard toolkit Package attributesSingle-instance environment For example, /etc/cmcluster/pkg/dgpkgSetting up Oracle Data Guard toolkit #ecmt/oracle/oracle/LISTENERRESTART Servicefailfastenabled no servicehalttimeout RAC environment For example, /etc/cmluster/pkg/racdgpkgWhere ocmnp is the Smnp package for Oracle CLusterware Adding the package to the Serviceguard cluster Maintaining Oracle Data Guard toolkitCluster verification for Oracle Data Guard toolkit Single-instance environmentTroubleshooting Pkg.conf commandLimitations Startstandbyasprimary to yes Prerequisites Using the DB2 Hadr toolkit Supported configurationWhen primary and standby packages are in the same cluster Event 1 Standby database or Hadr goes downEvent 2 Primary package fails When primary and standby packages are in different clusters Primary and Standby Packages in Different ClustersGo to the /etc/cmcluster/hadrprimary directory Creating packagesTo provide high availability only to primary database Cmmakepkg -m ecmt/db2/db2 -m tkit/db2hadr/db2hadr pkg.confInstancename Hadrip Maintaining packages Managing packagesRunning packages And, $ cmmodpkg -e hadrpkgHalting packages # cmhaltpkg packagenameHost key verification failed. Lost connection Limitations How to contact HP Information to collect before contacting HPDocumentation feedback Warranty informationHP authorized resellers Related information Typographic conventionsTIP Node3# /usr/bin/ssh-keygen -t dsa Db2 get db cfg for db2 database name grep -i hardNode3# /usr/bin/ssh-keygen -t rsa Node2# /usr/bin/ssh-keygen -t rsaPage To add a new key to/home/user/.ssh/knownhosts Page Glossary Index