IBM®
Skip to main content
    Country/region [select]      Terms of use
 
 
    
     Home      Products      Services & industry solutions      Support & downloads      My IBM     
developerworks > My developerWorks >  Dashboard > IBM Database Wiki > ... > Best Practices > Best Practice - DB2 High Availability Disaster Recovery
developerWorks
Log In   View a printable version of the current page.
Best Practice - DB2 High Availability Disaster Recovery
Added by torodanhan, last edited by torodanhan on Apr 01, 2009  (view change)
Labels: 

Go to All Best Practices Papers
Go to HADR wiki home
PDF format available at http://www.ibm.com/developerworks/db2/bestpractices/ (PDF version may not be up to date)


  DB2 High Availability Disaster Recovery

DB2 High Availability Disaster Recovery (HADR) is an easy to use data replication feature that provides a high availability (HA) solution for both partial and complete site failures.

However, given the sheer variety of users' requirements, there is no one ideal configuration for HADR. The decisions you make in setting up, tuning, and maintaining your HADR environment are often the result of weighing various pros and cons. For instance, you might need to balance the competing requirements of the availability of your database with protection from data loss. The good news is that this need to find a balance does not necessarily imply that one requirement needs to suffer.

This document provides a number of recommendations for setting up and maintaining your HADR environment in ways that help balance the protection HADR provides with performance and cost. The following specific areas of focus are covered:

  • Setting up your system for fast failovers
  • Tuning parameters to improve network performance
  • Tuning parameters to minimize the impact of HADR-related logging on performance
  • Choosing the right table reorganization method and load operation in an HADR environment

Table of contents

Best Practice - DB2 High Availability Disaster Recovery - 1. Introduction to HADR
Best Practice - DB2 High Availability Disaster Recovery - 2. Setting up your system
Best Practice - DB2 High Availability Disaster Recovery - 3. Tuning parameters
Best Practice - DB2 High Availability Disaster Recovery - 4. Database administration and maintenance
Best Practice - DB2 High Availability Disaster Recovery - 5. Performing load operations in an HADR environment
Best Practice - DB2 High Availability Disaster Recovery - 6. Conclusion
Best Practice - DB2 High Availability Disaster Recovery - 7. Best Practices Summary


    About IBM Privacy Contact