An Introduction to db2mon
The monitoring table functions are the best way to view Db2 monitoring statistics. Being able to use SQL to query the monitoring data is great but most of the metrics are cumulative since database activation. We created db2mon to perform deltas and produce reports.
Do you have a significant amount of work coming into your Db2 for z/OS subsystems through the Distributed Data Facility?
Statistics event monitors are an extremely useful way to get periodic monitoring of basic metrics on your system. They're just well-disguised behind a somewhat misleading name.
You can create profiles to selectively control groups of distributed (DBAT) threads and connections, set thresholds for query acceleration (not covered in this article) or provide override properties to model your test subsystem to reflect the computing power of your production environment.
I have a question about the total_extended_latch_wait_time monitor element. We recently saw high values of total_extended_latch_wait_time and we'd like to understand how to interpret this.