Chapter 3: Further Reading

IBM Official Documentation

IBM DB2 13 for z/OS: Administration Guide IBM Documentation. Comprehensive reference for DB2 z/OS administration including address space architecture, buffer pool management, logging, and catalog structures. https://www.ibm.com/docs/en/db2-for-zos/13
IBM DB2 13 for z/OS: Managing Performance IBM Documentation. Detailed guidance on buffer pool tuning, EDM pool sizing, RID pool management, sort pool configuration, and workload management. https://www.ibm.com/docs/en/db2-for-zos/13?topic=performance
IBM DB2 13 for z/OS: Utility Guide and Reference IBM Documentation. Reference for RUNSTATS, REORG, RECOVER, COPY, and other utilities discussed in this chapter. https://www.ibm.com/docs/en/db2-for-zos/13?topic=utilities

IBM Db2 11.5: Database Administration IBM Documentation. Covers instance architecture, process model, buffer pool management, tablespace types, and logging configuration. https://www.ibm.com/docs/en/db2/11.5?topic=administering
IBM Db2 11.5: Performance Tuning IBM Documentation. Detailed coverage of STMM, buffer pool tuning, sort heap configuration, package cache management, and the MON_GET_* monitoring functions. https://www.ibm.com/docs/en/db2/11.5?topic=performance
IBM Db2 11.5: Database Partition Feature (DPF) Guide IBM Documentation. Architecture and administration of multi-partition databases. https://www.ibm.com/docs/en/db2/11.5?topic=partitioning

DB2 for z/OS: Data Sharing in a Nutshell (SG24-8479) Covers the extended architecture of DB2 data sharing, including inter-system IRLM communication through the Coupling Facility. Essential reading if your environment uses data sharing groups.
DB2 11 for z/OS Technical Overview (SG24-8180) A comprehensive technical overview of DB2 z/OS architecture, including detailed diagrams of address space structures, memory pools, and internal component interactions.
DB2 for z/OS: Buffer Pool Monitoring and Tuning (REDP-4604) An IBM Redpaper focused specifically on buffer pool architecture, monitoring, and tuning strategies. Includes real-world examples of buffer pool analysis and optimization.
Optimizing DB2 Queries with IBM Data Server Manager (SG24-8436) Covers the SQL lifecycle from a performance perspective, including access path analysis, explain plan interpretation, and optimization strategies on both z/OS and LUW.
DB2 LUW Performance Tuning and Monitoring (SG24-8133) Covers LUW-specific performance topics including STMM internals, buffer pool analysis, lock tuning, and workload management using DB2 monitoring table functions.
An Introduction to DB2 for z/OS for DBAs Managing DB2 for LUW (REDP-5515) Specifically written for DBAs transitioning between platforms. Maps z/OS concepts to LUW equivalents and vice versa — directly relevant to the dual-platform theme of this chapter.

DB2 Developer's Guide by Craig Mullins (6th Edition, IBM Press) The most comprehensive single-volume reference for DB2 for z/OS. Chapters on DB2 architecture, buffer pools, logging, and the catalog are particularly relevant to this chapter. Mullins writes from decades of hands-on experience.
DB2 for z/OS and OS/390: Ready for Java by Dirk Wollscheid et al. Though focused on Java connectivity, the early chapters provide an excellent walkthrough of DDF/DIST architecture and how remote connections are processed — complementing Section 3.2.4 of this chapter.
DB2 SQL Tuning Tips for z/OS Developers by Tony Andrews Focuses on the SQL lifecycle from a developer's perspective, including how access paths are chosen, how the EDM pool and dynamic statement cache work, and how to write SQL that the optimizer can handle efficiently.

"Write-Ahead Logging" (WAL) — Original Research The theoretical foundation for DB2's logging system comes from the ARIES recovery algorithm. The foundational paper is: C. Mohan, D. Haderle, B. Lindsay, H. Pirahesh, and P. Schwarz. "ARIES: A Transaction Recovery Method Supporting Fine-Granularity Locking and Partial Rollbacks Using Write-Ahead Logging." ACM Transactions on Database Systems, 17(1), March 1992. This is an advanced academic paper, but understanding its core ideas deepens your appreciation for why DB2's recovery architecture works the way it does.
IBM developerWorks / IBM Community: DB2 Architecture Series IBM's developer community hosts numerous articles on DB2 internals. Search for topics like "DB2 buffer pool internals," "DB2 z/OS address space architecture," and "DB2 LUW memory model" for platform-specific deep dives.

IBM OMEGAMON for Db2 Performance Expert on z/OS The primary enterprise monitoring tool for DB2 z/OS. Documentation covers all the buffer pool, EDM pool, logging, and locking metrics discussed in this chapter. https://www.ibm.com/docs/en/omegamon-for-db2-pe-zos
IBM Data Server Manager A web-based monitoring and administration tool for DB2 LUW. Provides real-time buffer pool hit ratios, memory allocation dashboards, and STMM activity tracking. https://www.ibm.com/docs/en/dsm
DB2 LUW Monitoring Table Functions (MON_GET_*) The built-in table functions MON_GET_BUFFERPOOL, MON_GET_TABLESPACE, MON_GET_CONNECTION, MON_GET_PKG_CACHE_STMT, and others provide programmatic access to all performance metrics. Documentation: https://www.ibm.com/docs/en/db2/11.5?topic=functions-monitor-table