dbTalk Databases Forums  

DB2 Failover

comp.databases.ibm-db2 comp.databases.ibm-db2


Discuss DB2 Failover in the comp.databases.ibm-db2 forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
afreema@cio.sc.gov
 
Posts: n/a

Default DB2 Failover - 09-20-2007 , 02:54 PM






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


Reply With Quote
  #2  
Old   
Sanjuro
 
Posts: n/a

Default Re: DB2 Failover - 09-20-2007 , 03:36 PM






On Sep 20, 2:54 pm, afre... (AT) cio (DOT) sc.gov wrote:
Quote:
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')
..



Reply With Quote
  #3  
Old   
paul.lapointe.xkoto@gmail.com
 
Posts: n/a

Default Re: DB2 Failover - 10-02-2007 , 06:10 PM



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... (AT) gmail (DOT) com> wrote:
Quote:
On Sep 20, 2:54 pm, afre... (AT) cio (DOT) 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')
.



Reply With Quote
  #4  
Old   
Mark A
 
Posts: n/a

Default Re: DB2 Failover - 10-02-2007 , 08:28 PM



<paul.lapointe.xkoto (AT) gmail (DOT) com> wrote

Quote:
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?




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.