Summary
This guide focuses on the performance tuning of Db2 High Availability Disaster Recovery (HADR) systems. It outlines the configuration of HADR for optimal performance, including monitoring options and best practices. The document details the HADR implementation process, explaining how logged operations are replicated and what is not replicated. It describes various synchronization modes such as SYNC, NEARSYNC, ASYNC, and SUPERASYNC, highlighting their performance overhead and protection levels. The guide emphasizes the importance of network tuning for HADR performance, detailing how TCP performance affects log shipping and overall database throughput. It provides best practices for configuring TCP buffer sizes and monitoring key performance indicators related to HADR. Additionally, the document discusses log spooling as a solution for managing slow standby systems, allowing for efficient log shipping without affecting primary log writing. Overall, the guide serves as a comprehensive resource for optimizing Db2 HADR performance.
