DB2 HADR Performance Guide by Yuke Zhuge

When the DB2 HADR feature is enabled, the primary database's transaction logs are replicated to one or more standby databases in real time. The replication provides HA and DR protection, at a cost. The replication adds overhead to the primary's log writing. Applications on the primary may experience slow down. This white paper will focus on HADR performance specifically by adressing the configuration of HADR for optimal performance, monintoring HADR performance, and diagnosing and fixing HADR performance problems. A must read!!!

Click here for the full article.

 

 

1 Like
Recent Stories
Selecting Appropriate Data Architecture Technologies

SQL Tuning for Developers – Part 2 Explain Output

Some of my favorite tunings tips and tricks for DB2 by Joe Geller