HP Serviceguard Toolkits for Database Replication Solutions manual Overview, Prerequisites

Page 34

3 Serviceguard toolkit for DB2 High Availability Disaster Recovery

Overview

The HP Serviceguard toolkit for DB2 High Availability Disaster Recovery (DB2 HADR toolkit) enables you to configure the DB2 primary and standby database as two Serviceguard packages. It provides high availability for DB2 database and role management assistance, such as role takeover and role switch for DB2 HADR.

DB2 HADR toolkit handles role takeover automatically. When the primary database fails, standby package performs a role takeover. This process is faster than the entire process of stopping the database on one node and starting it on another node.

After role takeover, when the primary package is started, the database starts as standby because the primary database is already up. In this scenario, the standby package runs as a primary database and the primary package runs as a standby database. DB2 HADR toolkit can also be configured to perform a role switch to restore the configured role.

Advantages

When DB2 HADR is deployed in an HP Serviceguard cluster using DB2 HADR toolkit, it has the following advantages:

•Provides high availability for DB2 processes, for both primary and the standby database.

•Provides seamless role takeover and role switch features between databases both in the same and different clusters.

Dependencies

DB2 HADR toolkit requires the Enterprise Cluster Master Toolkit (ECMT) DB2 Toolkit.

Prerequisites

This section lists the prerequisites for DB2 HADR toolkit.

•Serviceguard A.11.20 must be installed on all nodes and the cluster must be configured.

•Enterprise Cluster Master Toolkit version B.06.00 must be installed.

•DB2 v9.7 must be installed. The database must be created, and HADR must be configured for that database. Both primary and standby should be able to start the database and HADR manually.

•Secure Shell (SSH) connection without password for root user must be set between the nodes on which the primary and standby packages are configured. The connection must be set using the interconnect traffic IP address or alias name used to configure DB2 HADR. For steps on how to configure SSH connection, see “ To configure SSH connection without password for root user between two nodes” (page 49)

•DB2 HADR must be configured using the same DB2 instance name on both primary and the standby database.

•If the DB2 HADR toolkit packages are configured in multiple subnet environment, use alias names for Interconnect traffic IP and to configure DB2 HADR. When multiple IP entries are created for an alias name in the /etc/hosts file, it enables the package to move through different subnets.

34 Serviceguard toolkit for DB2 High Availability Disaster Recovery

Page 33 Page 35
Image 34
Page 33 Page 35
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 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 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 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
Top Page Image Contents