IDUG NA 2025

Db2 offers many rich data monitoring sources to collect, but how do you decide what is important or useful to collect? This session looks at regular db2mon data collection with  a focus on extracting insights from the data, both from a single db2mon report and also from multiple data collections over time.
This session will cover many performance metrics including
– system basics – activity, utilization– bottleneck checks – waiting on disk, network, locks, etc.– bufferpool activity and effectiveness– insights over time – looking at metrics from multiple reports and charting important trends
R provides a rich and repeatable set of data manipulations that provide a flexible and composable set of tools to dig into and chart the db2mon data. This is supplemented by custom Db2–developed tooling that is now open–sourced to convert multiple db2mon reports into data files grouped by report types for deeper insights on database behaviour.