Chapter 29 Further Reading

IBM Official Documentation

  • DB2 LUW High Availability and Disaster Recovery Guide (SC27-5737) The primary IBM reference for HADR configuration, operation, and troubleshooting. Covers all synchronization modes, multiple standby configurations, takeover procedures, and monitoring. Essential reading for any LUW DBA implementing HADR.

  • DB2 LUW Data Recovery and High Availability Guide and Reference Comprehensive guide covering HADR, backup/recovery integration, and the relationship between HADR and other DB2 features. Includes detailed parameter descriptions and tuning guidance.

  • Db2 pureScale Feature: Installation and Upgrade Guide Complete documentation for deploying pureScale clusters, including prerequisites, cluster caching facility configuration, GPFS setup, and member management.

  • IBM InfoSphere Data Replication Documentation Covers Q Replication and CDC in detail, including capture and apply configuration, subscription management, conflict resolution, and performance tuning.

IBM Redbooks

  • High Availability and Scalability Guide for DB2 on Linux, UNIX, and Windows (SG24-8168) An excellent IBM Redbook covering HADR, pureScale, and other LUW HA technologies with practical deployment scenarios, performance benchmarks, and best practices from real implementations.

  • DB2 pureScale: Risk Free Agile Scaling (SG24-8212) Detailed Redbook on pureScale architecture, deployment, and operation. Includes comparison with z/OS data sharing, performance characteristics, and migration guidance from non-pureScale environments.

  • Implementing IBM InfoSphere Data Replication (SG24-8109) Practical guide to implementing Q Replication and CDC, including step-by-step setup instructions, monitoring, and troubleshooting. Covers common deployment patterns and integration with downstream systems.

  • DB2 LUW Performance Tuning and Monitoring (SG24-8321) While focused on general performance, this Redbook includes chapters on HADR performance impact, pureScale tuning, and monitoring strategies relevant to HA environments.

HADR Deep Dives

  • "HADR Best Practices" — IBM Developer A frequently updated article covering HADR configuration best practices, common pitfalls, and tuning recommendations. Includes guidance on HADR_PEER_WINDOW, HADR_TIMEOUT, and synchronization mode selection.

  • "Automatic Client Reroute and High Availability" — IBM Knowledge Center Detailed documentation on ACR configuration for all client drivers (JDBC, CLI, .NET, Python). Includes db2dsdriver.cfg examples, connection retry logic, and seamless ACR behavior.

  • "HADR with Multiple Standbys" — IBM Support Technote Technical note explaining the configuration of principal, auxiliary, and delayed standbys. Includes role management, promotion procedures, and operational considerations.

pureScale Resources

  • "Db2 pureScale Architecture White Paper" — IBM Technical whitepaper explaining the pureScale architecture in depth, including the cluster caching facility, RDMA communication, and comparison with other shared-everything and shared-nothing architectures.

  • "pureScale Performance: Achieving Linear Scalability" — IBM Developer Performance benchmarks and tuning guidance for pureScale clusters. Discusses member scaling characteristics, CF node sizing, and workload patterns that benefit from pureScale.

Replication Technologies

  • "Q Replication: Low Latency, Event-Driven Replication" — IBM Developer Overview of Q Replication architecture, deployment patterns, and use cases. Includes bidirectional replication design and conflict resolution strategies.

  • "Change Data Capture with Apache Kafka" — IBM Developer Guide to integrating DB2 CDC with Apache Kafka, including Kafka Connect setup, topic design, and consumer patterns. Covers the Debezium CDC connector as an alternative to IBM's CDC product.

  • Debezium Connector for Db2 (Open Source) An open-source alternative for CDC from DB2 to Kafka. Built on the Debezium platform, it provides log-based change capture with Kafka Connect integration. Documentation at debezium.io.

Cluster Management

  • "Configuring Pacemaker for DB2 HADR" — IBM Support Step-by-step guide for integrating Pacemaker with DB2 HADR for automatic failover on Linux. Includes resource agent configuration, quorum setup, and fencing strategies.

  • "PowerHA SystemMirror for DB2" — IBM Documentation Guide for integrating PowerHA with DB2 HADR on AIX systems. Covers Smart Assist for DB2, which automates HADR failover configuration.

  • "IBM Tivoli System Automation for DB2 HADR" — IBM Redbooks Covers the integration of Tivoli SA with DB2 HADR for automated failover, monitoring, and recovery on z/Linux and other platforms.

Community and Conference Resources

  • IDUG (International DB2 Users Group) IDUG conferences feature multiple sessions on LUW HA technologies each year. The IDUG Tech Conference and Db2 Technical Community provide access to presentations, recordings, and expert discussions.

  • IBM Data and AI Community Online community with forums, blogs, and technical articles about DB2 LUW, including HADR, pureScale, and replication. Accessible at community.ibm.com/data.

  • Stack Overflow — db2 Tag Active community answering DB2 questions, including HADR configuration, troubleshooting, and ACR issues. Search for [db2] [hadr] for focused results.

  • Chapter 18: Concurrency and Locking — Isolation levels and their impact on reads-on-standby
  • Chapter 20: Application Development — Connection management and error handling for HADR-aware applications
  • Chapter 28: Data Sharing and Parallel Sysplex — The z/OS equivalent of pureScale and multi-member clustering
  • Chapter 30: Backup, Recovery, and Business Continuity — Backup strategies that complement HADR and replication