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
|