Skip to main content

By clicking Submit, you agree to the developerWorks terms of use.

The first time you sign into developerWorks, a profile is created for you. Select information in your developerWorks profile is displayed to the public, but you may edit the information at any time. Your first name, last name (unless you choose to hide them), and display name will accompany the content that you post.

All information submitted is secure.

  • Close [x]

The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerworks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

By clicking Submit, you agree to the developerWorks terms of use.

All information submitted is secure.

  • Close [x]

Select a language:

  • Close [x]
  • Close [x]

Using DB2 High Availability Disaster Recovery with Tivoli Systems Automation and Reliable Scalable Cluster Technology

Troubleshooting your DB2 high availability integrated solution

Dipali Kapadia (dkapadia@ca.ibm.com), DB2 Continuing Engineering Software Developer, IBM
Photo of Dipali Kapadia
Dipali Kapadia has been with IBM for four years. She is currently working in DB2 Continuing Engineering for High Availability (HA), working on production problems and further enhancements on the HA component. Dipali holds a Bachelor of Engineering, specializing in Software Design from McMaster University. Dipali also has one previous developerWorks article.
Michelle Chiu (mtmchiu@ca.ibm.com), DB2 Continuing Engineering Software Developer, IBM
Michelle Chiu
Michelle Chiu has been with the DB2 Continuing Engineering HA team since the introduction of the integrated solution in DB2 9.5 release. She has assisted customers in the adoption of this solution and has driven numerous functionality and serviceability improvements. Michelle holds an Honours Bachelor of Mathematics degree from the University of Waterloo, specializing in Computer Science - Bioinformatics.

Summary: 

The IBM DB2 High Availability (HA) feature, introduced in IBM DB2 9.5 for Linux, UNIX, and Windows, enables a new level of integration between the data server and cluster management software, providing a unified High Availability Disaster Recovery (HADR) automation framework. In this tutorial, get an introduction to this integrated solution, and learn about useful diagnostic tools for working with DB2 and Tivoli Systems Automation, a key piece of the solution. Achieve the highest possible level of performance and reliability for your data, understanding how to solve problems and address issues.

This tutorial is meant for readers who have some knowledge of HADR, but may be new to the integrated solution—DB2 with IBM Tivoli® Systems Automation (TSA) and IBM Reliable Scalable Cluster Technology (RSCT).

Date:  30 Sep 2010
Level:  Intermediate
PDF:  A4 and Letter (185 KB | 35 pages)Get Adobe® Reader®

Activity:  34546 views
Comments:  

Introduction to the DB2 High Availability feature

In today's fast-paced world, time is money. More importantly, downtime equals money lost. This is why high availability is so important for all businesses, large and small. A highly available database solution ensures that, should any integral part of your database solution go down, your system would seamlessly fail over to a backup. However, without a cluster manager, this "failover" is not automatic. A database administrator must be paged, and must physically go to the database server and manually issue a takeover command. This is where the power of the integrated HA solution comes into play.

The integrated HA solution, called the DB2 High Availability feature, was introduced in DB2 9.5. In this solution, a cluster manager, Tivoli Systems Automation / Reliable Scalable Cluster Technology (TSA/RSCT), comes bundled with DB2 for Linux, UNIX, and Windows Workgroup Edition and Enterprise Edition. It is responsible for monitoring integral database resources and, in the event of a failure, taking the appropriate action. The main advantages of the integrated solution are:

  • It is simple: The DBA does not need to learn a new set of cluster manager commands to manage resources.
  • It is integrated: Using the db2haicu tool, DB2 seamlessly interacts with TSA, triggering the correct actions. DB2 comes with TSA/RSCT bundled. As you apply DB2 fix packs, the fix packs automatically upgrade your TSA/RSCT level to pick up critical TSA/RSCT fixes, if necessary.

In a typical integrated HA solution configuration, TSA/RSCT is installed on both hosts. It is responsible for monitoring entities such as network interfaces, DB2 instances, and HADR databases. The client connects to the primary database using the public network using a virtual IP address. In the event of a failure on the primary host, this virtual IP address fails over to the standby. From the perspective of the client, there is no down time, as the transition is automatic. If there are two network interfaces on each host, a private network can be set up exclusively for HADR replication.


Figure 1. Integrated HA solution
User is connected through public network to primary network and standby server, which are connect to one another for HADR replication over a private network

Prerequisites

The integrated HA solution using TSA/RSCT as the cluster manager is available for use on Linux and AIX in DB2 9.5 for Linux, UNIX, and Windows and later, and on Solaris in V9.7 and later.

1 of 6 | Next

Comments

Back to top

Close [x]

Help: Update or add to My dW interests

What's this?

This little timesaver lets you update your My developerWorks profile with just one click! The general subject of this content (AIX and UNIX, Information Management, Lotus, Rational, Tivoli, WebSphere, Java, Linux, Open source, SOA and Web services, Web development, or XML) will be added to the interests section of your profile, if it's not there already. You only need to be logged in to My developerWorks.

And what's the point of adding your interests to your profile? That's how you find other users with the same interests as yours, and see what they're reading and contributing to the community. Your interests also help us recommend relevant developerWorks content to you.

View your My developerWorks profile

Return from help

Close [x]

Help: Remove from My dW interests

What's this?

Removing this interest does not alter your profile, but rather removes this piece of content from a list of all content for which you've indicated interest. In a future enhancement to My developerWorks, you'll be able to see a record of that content.

View your My developerWorks profile

Return from help

static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management, Tivoli
ArticleID=548331
TutorialTitle=Using DB2 High Availability Disaster Recovery with Tivoli Systems Automation and Reliable Scalable Cluster Technology
publish-date=09302010
author1-email=dkapadia@ca.ibm.com
author1-email-cc=
author2-email=mtmchiu@ca.ibm.com
author2-email-cc=

Table of contents

1 of 6 | Next

Next steps from IBM

Tags

Help
Use the search field to find all types of content in My developerWorks with that tag.

Use the slider bar to see more or fewer tags.

Popular tags shows the top tags for this particular content zone (for example, Java technology, Linux, WebSphere).

My tags shows your tags for this particular content zone (for example, Java technology, Linux, WebSphere).

Use the search field to find all types of content in My developerWorks with that tag. Popular tags shows the top tags for this particular content zone (for example, Java technology, Linux, WebSphere). My tags shows your tags for this particular content zone (for example, Java technology, Linux, WebSphere).

 

Dig deeper into Information Management on developerWorks

Try IBM PureSystems. No charge.

IBM PureSystems on a kaleideoscope background

Experience today!

Get started with the cloud-based trial and pattern development kit.

Share this page:

  • Close [x]

Follow developerWorks:

  • Close [x]