DB2 for z/OS Administration Guide — Chapter on Monitoring and Tuning. IBM Knowledge Center. Covers DISPLAY commands, trace configuration, and SMF record interpretation in exhaustive detail.
DB2 for z/OS Messages and Codes — Reference for all DSNV, DSNB, DSNJ, and DSNT message prefixes encountered in DISPLAY command output and diagnostic messages.
DB2 for z/OS Performance Monitoring and Tuning Guide — SC27-8850. The definitive reference for z/OS performance management, including IFCID descriptions, accounting record field definitions, and performance trace analysis.
DB2 for z/OS Instrumentation Facility Interface Reference — Detailed descriptions of every IFCID, including record layouts and field meanings.
OMEGAMON for DB2 Performance Expert on z/OS User's Guide — IBM SH12-6963. Installation, configuration, and usage of OMEGAMON for DB2 monitoring.
LUW
DB2 LUW Monitoring Guide — IBM Knowledge Center. Comprehensive coverage of snapshot monitors, MON_GET table functions, event monitors, and db2pd.
DB2 LUW Troubleshooting and Tuning Database Performance — IBM Knowledge Center. Covers db2diag.log analysis, FFDC, db2support, and systematic problem determination.
DB2 LUW Administrative Routines and Views — Reference for all MON_GET_* table functions, including column definitions, usage notes, and examples.
DB2 LUW SQL Reference — CREATE EVENT MONITOR, SET EVENT MONITOR STATE, and related SQL statements for event monitor management.
Books
DB2 Performance Expert for Multiplatforms V3.2 — IBM Redbook SG24-7357. Practical guide to using Performance Expert for monitoring and tuning, with real-world scenarios.
DB2 Monitoring and Tuning by Philip K. Gunning — Focuses on systematic approaches to performance monitoring with practical examples on both platforms.
DB2 Developer's Guide by Craig Mullins, 6th Edition — Chapters 24-26 cover monitoring, performance tuning, and problem determination with depth appropriate for both developers and DBAs.
DB2 for z/OS and OS/390 Development for Performance by Gabrielle Wiorkowski and David Kull — Classic reference for z/OS performance, with extensive coverage of trace analysis and accounting report interpretation.
Advanced DBA Certification Guide and Reference for DB2 Universal Database v8 for Linux, UNIX and Windows by Dwaine Snow and Thomas Phan — Chapter on monitoring and problem determination remains relevant for foundational concepts.
IBM Redbooks
DB2 9 for z/OS Performance Topics — SG24-7473. Covers monitoring improvements in DB2 9, including enhanced DISPLAY commands and new IFCIDs.
DB2 10 for z/OS Performance Topics — SG24-7942. New monitoring capabilities in DB2 10, including improved accounting and statistics records.
DB2 11 for z/OS Performance Topics — SG24-8222. Monitoring enhancements including new IFCID records and improved DISPLAY command output.
DB2 12 for z/OS Performance Topics — SG24-8418. Latest monitoring features including enhanced statistics and improved buffer pool monitoring.
Optimizing DB2 Queries with IBM DB2 Analytics Accelerator — SG24-8005. Monitoring considerations when using IDAA, including new IFCIDs and accounting record fields.
DB2 11.1 Certification Study Guide — SG24-8293. Chapter 7 covers monitoring for the DB2 LUW DBA certification exam.
Technical Articles and Blog Posts
"db2pd — A Practical Guide" — IBM Developer. Comprehensive walkthrough of db2pd options with real-world examples and output interpretation.
"Understanding MON_GET Table Functions" — IBM Developer. Tutorial on transitioning from snapshot monitors to MON_GET functions with side-by-side comparisons.
"First Failure Data Capture in DB2" — IBM Support. Technical explanation of FFDC architecture, trap file analysis, and diagnostic data collection.
"Buffer Pool Tuning in DB2" — IBM Developer. Detailed analysis of buffer pool sizing, hit ratio interpretation, and prefetch optimization.
"Deadlock Analysis in DB2 for z/OS" — IBM Developer. How to read IFCID 044 and 196 records to diagnose deadlock chains.
Tools and Utilities
IBM Data Server Manager — Web-based monitoring and administration tool for DB2 LUW. Provides real-time monitoring dashboards, alert management, and historical data analysis without requiring custom SQL scripts.
IBM OMEGAMON for DB2 Performance Expert on z/OS — Enterprise-grade monitoring with real-time dashboards, threshold alerting, exception processing, and historical reporting.
BMC MainView for DB2 — Third-party monitoring product for z/OS with thread advisor, SQL workspace, and automated recovery capabilities.
Grafana with DB2 data source — Open-source dashboard tool that can connect to DB2 monitoring tables for custom visualization. Useful for LUW environments without commercial monitoring products.
db2top — Interactive real-time monitoring tool for DB2 LUW, similar to the Unix top command. Provides a quick overview of database activity from the command line.
Related Topics for Deeper Study
Chapter 15 (Query Optimization) — Understanding access paths is essential for interpreting monitoring data. A buffer pool hit ratio decline often traces back to an optimizer decision.
Chapter 17 (Utilities) — Monitoring tells you when utilities are needed. RUNSTATS, REORG, and COPY operations are driven by monitoring data.
Chapter 19 (Security) — Audit traces (z/OS) and audit event monitors (LUW) are monitoring tools applied to security events. Review Chapter 19's security monitoring alongside this chapter's operational monitoring.
Chapter 22 (Performance Tuning) — Monitoring identifies problems; tuning resolves them. These two chapters are inseparable in practice.
Community Resources
IDUG (International DB2 Users Group) — Annual conferences and regional meetings with sessions dedicated to monitoring and performance. IDUG Solutions Journal publishes monitoring-related articles.
IBM Support Portal — Searchable database of known issues, APARs, and fix packs. Many monitoring-related problems are documented with specific diagnostic steps.
Stack Overflow — [db2] tag — Community Q&A for specific monitoring queries, db2pd interpretation, and event monitor configuration.
IBM Champions Program — IBM Champions in the DB2 space frequently publish blog posts and presentations on advanced monitoring techniques.