473,395 Members | 1,526 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

DB2 Failover

I am interested in failover for DB2 Version 9 on an AIX environment.
Can you give me any recommendations?

Sep 20 '07 #1
3 4569
On Sep 20, 2:54 pm, afre...@cio.sc.gov wrote:
I am interested in failover for DB2 Version 9 on an AIX environment.
Can you give me any recommendations?
You may achieve several levels of high availability for DB2 v9 on AIX.
Any of the following (as stand-alone) and preferably a combination of
several strategies should be used to achieve a robust failover/high
available environment.

x. Database Backup strategy through DB2 utilities. No third party
software needed.
x. High availability through DB2 HADR (High Availability Disaster
Recovery). You won't need any third party software for this. Protects
against site failure or server failure. For automatic failover, you
'll need additional clustering software. DB2 bundles Tivoli Software
Automation with DB2 on Linux, AIX for free.
x. File system bitmap standby image using Flascopy-like tools. Storage
must be on EMC (IBM) like SAN for Flashcopy.
x. HACMP on AIX. Would protect against hardware failure. Can also be
configured to use with HADR for automatic database failover.
x. Grid Clustering HA with xkoto and similar products. Most
sophisticated and possibly-most expensive.

For guidance on HADR look at these: http://www.ibm.com/developerworks/vi...ibraryview.jsp
(search for 'hadr')
..

Sep 20 '07 #2
I'm an ITS at xkoto, if you need any technical information on xkoto
GRIDSCALE, I can provide.

In terms of cost, GRIDSCALE is less expensive then most comparable
options available, especially if you take in to consideration pricing
for a complete solution, or if you are considering investing in a SAN
simply to delivery HA.

On Sep 20, 1:36 pm, Sanjuro <ashru...@gmail.comwrote:
On Sep 20, 2:54 pm, afre...@cio.sc.gov wrote:
I am interested in failover for DB2 Version 9 on an AIX environment.
Can you give me any recommendations?

You may achieve several levels of high availability for DB2 v9 on AIX.
Any of the following (as stand-alone) and preferably a combination of
several strategies should be used to achieve a robust failover/high
available environment.

x. Database Backup strategy through DB2 utilities. No third party
software needed.
x. High availability through DB2 HADR (High Availability Disaster
Recovery). You won't need any third party software for this. Protects
against site failure or server failure. For automatic failover, you
'll need additional clustering software. DB2 bundles Tivoli Software
Automation with DB2 on Linux, AIX for free.
x. File system bitmap standby image using Flascopy-like tools. Storage
must be on EMC (IBM) like SAN for Flashcopy.
x. HACMP on AIX. Would protect against hardware failure. Can also be
configured to use with HADR for automatic database failover.
x. Grid Clustering HA withxkotoand similar products. Most
sophisticated and possibly-most expensive.

For guidance on HADR look at these:http://www.ibm.com/developerworks/vi...ibraryview.jsp
(search for 'hadr')
.

Oct 2 '07 #3
<pa*****************@gmail.comwrote in message
news:11**********************@22g2000hsm.googlegro ups.com...
I'm an ITS at xkoto, if you need any technical information on xkoto
GRIDSCALE, I can provide.

In terms of cost, GRIDSCALE is less expensive then most comparable
options available, especially if you take in to consideration pricing
for a complete solution, or if you are considering investing in a SAN
simply to delivery HA.
So what happened to the rumors of an IBM purchase of Xkoto?
Oct 3 '07 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Sue | last post by:
I'm having a problem understanding how TAF to a standby database in jdbc would work. I currently have a production database with a standby database. I understand that I need to set some failover...
1
by: Nico de Groot | last post by:
I have a 2 node Microsoft 2000 cluster with a shared storage device. I want to create automatic failover for MS SQL 2000 server. I can do that wit the following options: 1. Active/Pasive (one...
1
by: kumar | last post by:
Dear Friends, I wanted to configure Failover cluster for SQL Server 2000 on Windows 2000 advanced servers. I have only 2 no.s of windows 2000 advanced server m/cs. I dont have any shared...
1
by: pthawley | last post by:
All, I am doing some preliminary research on HA failover capabilities on DB2/UDB 8.1. The docs are a little light on details so I thought I'd ask this forum ...
1
by: news.microsoft.com | last post by:
Is there an elegant way to clear out the ADO connection pool used by the SQL Server State Service following a cluster failover? We are using a SQL Cluster to store both the ASP Session State...
5
by: uspensky | last post by:
We are trying to setup a system to system failover cluster using two nodes (x346) which each have a single hba running to seperate controllers on the DS400. For full redundnancy, IBM recommends...
1
by: theSpinel | last post by:
Is it possible to failover a single or a selected number of databases onto a standby server? We're currently log shipping about 12 databases to a standby and I was wondering if it was possible to...
0
by: Vinod Sadanandan | last post by:
Fast-Start Failover An Overview In Dataguard Environment ============================================================================= This article describes the automatic fast start failover...
8
by: Guy Macon | last post by:
How to increase web server uptime with DNS failover: For illustration, let's start with some really bad hosting... Find four free web hosts that are each 90% reliable -- in other words they...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.