Chapter 36 Further Reading

System Health Assessment and Monitoring

  • IBM Redbook: "DB2 11 for z/OS Performance Topics" (SG24-8222) — Comprehensive coverage of performance monitoring, workload management, and tuning methodologies. Essential reading for anyone conducting DB2 performance assessments.

  • IBM Redbook: "DB2 for z/OS: Data Sharing in a Nutshell" (SG24-8401) — Detailed guidance on data sharing group management, coupling facility configuration, and troubleshooting — directly applicable to the z/OS architecture review in this chapter.

  • IBM Db2 Knowledge Center: "Monitoring and Performance" — The definitive reference for all MON_GET table functions, snapshot monitoring, and event monitoring. Available online at the IBM documentation site.

Stress Testing and Performance Engineering

  • "The Art of Capacity Planning" by John Allspaw (O'Reilly, 2008) — While not DB2-specific, this book provides an excellent framework for capacity planning and stress testing in any infrastructure environment. The principles of baseline establishment, workload modeling, and growth projection apply directly.

  • "Systems Performance: Enterprise and the Cloud" by Brendan Gregg (Prentice Hall, 2nd Edition, 2020) — A comprehensive guide to systems performance analysis. The methodologies for CPU, memory, I/O, and network analysis complement the DB2-specific techniques in this chapter.

  • Apache JMeter Documentation (jmeter.apache.org) — If you are building stress test workloads for DB2, JMeter with the JDBC sampler is one of the most accessible tools. The official documentation covers configuration, thread groups, and result analysis.

Disaster Recovery

  • IBM Redbook: "High Availability and Disaster Recovery with DB2 for LUW" (SG24-8370) — Detailed coverage of HADR configuration, failover procedures, Automatic Client Reroute, and DR testing methodologies.

  • IBM Redbook: "IBM Geographically Dispersed Parallel Sysplex (GDPS)" — For z/OS environments, this covers the end-to-end DR architecture including coupling facility management, log replication, and cross-site recovery.

  • "Disaster Recovery Planning: Strategies for Protecting Critical Information Assets" by Jon William Toigo (Prentice Hall, 3rd Edition) — A broader perspective on DR planning that helps DBAs understand how database recovery fits into the overall enterprise DR strategy.

Security and Compliance

  • PCI DSS v4.0 Documentation (pcisecuritystandards.org) — The authoritative source for PCI-DSS requirements. Section 3 (Protect Stored Account Data), Section 7 (Restrict Access), and Section 10 (Log and Monitor) are most relevant to DB2 security.

  • IBM Db2 Knowledge Center: "Security" — Covers authentication, authorization, LBAC, RCAC, audit policies, and encryption configuration. The reference for all security features demonstrated in Section 36.6.

  • "Database Security" chapter in "DB2 Developer's Guide" by Craig Mullins — A practical treatment of DB2 security from an administrative perspective, including real-world examples of security policy implementation.

Capacity Planning

  • "Capacity Planning for Web Services: Metrics, Models, and Methods" by Daniel A. Menasce and Virgilio A.F. Almeida (Prentice Hall) — Provides mathematical models for capacity planning that can be applied to database workloads. Useful for converting raw monitoring data into formal projections.

  • IBM Documentation: "Estimating Storage Requirements" — IBM's guidance on estimating storage for DB2 tables, indexes, and temporary objects. Essential for accurate capacity projections.

Executive Communication for Technical Professionals

  • "Presenting to Win" by Jerry Weissman — Techniques for presenting technical information to non-technical audiences. Directly applicable to the executive summary skills discussed in Section 36.11.

  • "The Pyramid Principle" by Barbara Minto — A framework for structuring business communication that starts with the conclusion and supports it with evidence. The executive summary format in this chapter follows this principle.

DB2 Reference Documentation

  • IBM Db2 for LUW 11.5 Knowledge Center — docs.ibm.com — The complete reference for all SQL, administration commands, configuration parameters, and monitoring interfaces used in this chapter.

  • IBM Db2 for z/OS 13 Knowledge Center — The complete reference for z/OS-specific utilities, commands, and subsystem configuration.

  • IBM DB2 SQL Reference — For the specific SQL syntax of all queries demonstrated in this chapter, including MON_GET functions, SYSCAT views, and administrative routines.