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')
..