Willie Favero is currently an IBM Senior Certified IT Software Specialist and the DB2 for z/OS SME for the Data Warehouse on System z Swat Team at IBM's Silicon Valley Lab. He is also a member of IBM's zChampion team, a representative for System z with IBM's Academic Initiative , an IBM Certified DBA for DB2 10 for z/OS, DB2 9 for zOS, and DB2 for z/OS Version 8, an IBM Certified DB2 9 and DB2 10 System Administrator for z/OS , and certified on DB2 UDB and DB2 for OS/390 Version 7.
Next up is a brand new Redbook. I just love Redbooks. They are one of our best tools (if not the best tool) available from IBM for keeping up-to-date with the latest and greatest DB2 for z/OS functionality. They’ve been a significant part of my “DB2 learning toolbox” ever since an IBM Sales Rep gave me my first one back in 1980.
Today’s Redbooks is “ Subsystem and Transaction Monitoring and Tuning with DB2 11 for z/OS” (SG24-8182-00). It’s available for download in PDF and EPUB formats and other than the Redbooks website, can be downloaded from iBookstore and Google play. I haven’t had a chance to read through it yet however, I can assure you it will be an excellent read based on the a couple of the authors, folks I know and have worked with that always do excellent work.
The next chunk of text has been copied directly from the Redbook page describing this Redbook... no point reinventing the wheel...
This IBM® Redbooks® publication discusses in detail the facilities of DB2® for z/OS®, which allow complete monitoring of a DB2 environment. It focuses on the use of the DB2 instrumentation facility component (IFC) to provide monitoring of DB2 data and events and includes suggestions for related tuning.
We discuss the collection of statistics for the verification of performance of the various components of the DB2 system and accounting for tracking the behavior of the applications.
We have intentionally omitted considerations for query optimization; they are worth a separate document.
Use this book to activate the right traces to help you monitor the performance of your DB2 system and to tune the various aspects of subsystem and application performance.
Table of contents
Part 1. Introduction to DB2 monitoring
Chapter 1. Introduction to monitoring and tuning
Chapter 2. DB2 traces
Chapter 3. System z related information
Part 2. Subsystem monitoring
Chapter 4. System address space CPU time
Chapter 5. EDM pools
Chapter 6. Data set open and close
Chapter 7. Log activity
Chapter 8. IRLM, locking, and latching
Chapter 9. The zIIP engine and DB2
Chapter 10. Buffer pools and group buffer pools
Chapter 11. DDF activity
Chapter 12. Work files, RID, and sort pools
Chapter 13. Virtual and real storage
Part 3. Transaction monitoring
Chapter 14. Accounting trace overview
Chapter 15. Analyzing accounting data: CPU and suspension time
Chapter 16. I/O suspensions
Chapter 17. Locking, latching, and buffer pool accounting counters
Chapter 18. Service task suspension
Chapter 19. Stored procedures, user defined functions, and triggers
Chapter 20. DRDA, parallelism, and statement cache
Appendix A. Production modeling
Appendix B. IBM OMEGAMON XE for DB2 performance database