HP Serviceguard Toolkits for Database Replication Solutions manual

Page 52

B Sample package configuration file for the DB2 HADR standby package

This section provides with a sample package configuration file for the DB2 HADR standby package:

#**********************************************************************

#****** HIGH AVAILABILITY PACKAGE CONFIGURATION FILE (template) *******

#**********************************************************************

#******* Note: This file MUST be edited before it can be used. ********

#* For complete details about package parameters and how to set them, *

#* consult the Serviceguard manual.

#**********************************************************************

package_name hadr_standby

package_description "Serviceguard Standby Package"

package_type failover

node_name node1

script_log_file /etc/cmcluster/hadr_standby/$SG_PACKAGE.log

#************ ECMT DB2TOOLKIT PARAMETERS ************

ecmt/db2/db2/TKIT_DIR /etc/cmcluster/hadr_standby ecmt/db2/db2/ALERT_MAIL_ID mailid@hp.com ecmt/db2/db2/INSTANCE_NAME db2inst1 ecmt/db2/db2/PARTITION_NUMBER 0 ecmt/db2/db2/MONITOR_PROCESSES db2sysc ecmt/db2/db2/MAINTENANCE_FLAG yes ecmt/db2/db2/MONITOR_INTERVAL 30 ecmt/db2/db2/TIME_OUT 30

service_name db2_service

service_cmd "$SGCONF/scripts/ecmt/db2/tkit_module.sh db2_monitor" service_restart none

service_fail_fast_enabled no service_halt_timeout 300

service_name db2hard_service

service_cmd "$SGCONF/scripts/tkit/db2hadr/tkit_module.sh db2hadr_monitor" service_restart none

service_fail_fast_enabled no service_halt_timeout 300

#************ DB2-HADR TOOLKIT PARAMETERS ************

tkit/db2hadr/db2hadr/HADR_ROLE standby tkit/db2hadr/db2hadr/HADR_DATABASE sample tkit/db2hadr/db2hadr/ROLE_MANAGEMENT yes tkit/db2hadr/db2hadr/HADR_IP 10.76.1.200:10.76.1.0 tkit/db2hadr/db2hadr/RESTORE_ROLE yes

#Provide Client traffic IP and Interconnect traffic IP as package IP, if the # package is configured to failover to another node.

ip_subnet 10.76.1.0

ip_address 10.76.1.100

#Provide VG name if the database is configured in a VG. vg vg_standby

NOTE: To configure the package configuration file for a primary package, add primary as the HADR_ROLE attribute. You must change the service_name attribute for both DB2 and DB2 HADR, if the primary package is also configured in the same cluster.

52 Sample package configuration file for the DB2 HADR standby package

Page 51 Page 53
Image 52
Page 51 Page 53
Contents HP Part Number Published August Edition Page Contents Glossary Index Introduction Overview AdvantagesDependencies Supported configurationSingle-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 clusterSetting up Oracle Data Guard toolkit Installing and uninstalling Oracle Data Guard toolkit# swinstall -s depot path 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 environmentPkg.conf command TroubleshootingLimitations 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 ClustersCreating packages To provide high availability only to primary databaseGo to the /etc/cmcluster/hadrprimary directory Cmmakepkg -m ecmt/db2/db2 -m tkit/db2hadr/db2hadr pkg.confInstancename Hadrip Managing packages Running packagesMaintaining packages And, $ cmmodpkg -e hadrpkgHalting packages # cmhaltpkg packagenameHost key verification failed. Lost connection Limitations How to contact HP Information to collect before contacting HPWarranty information HP authorized resellersDocumentation feedback Related information Typographic conventionsTIP Db2 get db cfg for db2 database name grep -i hard Node3# /usr/bin/ssh-keygen -t rsaNode3# /usr/bin/ssh-keygen -t dsa Node2# /usr/bin/ssh-keygen -t rsaPage To add a new key to/home/user/.ssh/knownhosts Page Glossary Index
Top Page Image Contents