472,807 Members | 1,749 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,807 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 4534
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...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 2 August 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: erikbower65 | last post by:
Using CodiumAI's pr-agent is simple and powerful. Follow these steps: 1. Install CodiumAI CLI: Ensure Node.js is installed, then run 'npm install -g codiumai' in the terminal. 2. Connect to...
0
linyimin
by: linyimin | last post by:
Spring Startup Analyzer generates an interactive Spring application startup report that lets you understand what contributes to the application startup time and helps to optimize it. Support for...
0
by: Taofi | last post by:
I try to insert a new record but the error message says the number of query names and destination fields are not the same This are my field names ID, Budgeted, Actual, Status and Differences ...
14
DJRhino1175
by: DJRhino1175 | last post by:
When I run this code I get an error, its Run-time error# 424 Object required...This is my first attempt at doing something like this. I test the entire code and it worked until I added this - If...
0
by: Rina0 | last post by:
I am looking for a Python code to find the longest common subsequence of two strings. I found this blog post that describes the length of longest common subsequence problem and provides a solution in...
5
by: DJRhino | last post by:
Private Sub CboDrawingID_BeforeUpdate(Cancel As Integer) If = 310029923 Or 310030138 Or 310030152 Or 310030346 Or 310030348 Or _ 310030356 Or 310030359 Or 310030362 Or...
0
by: Mushico | last post by:
How to calculate date of retirement from date of birth
2
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

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.