db2mon

I’ve been working with Db2 for Linux, UNIX and Windows for almost 30 years. The monitoring capabilities provided with the product are substantial and can be used to provide all the monitoring and performance data one needs to ensure Db2 is performing as expected. I’ve had scripts that capture and rank the top suboptimal SQL for all of those years, along with scripts using either snapshot or table functions to gather the other data such as bufferpool, tablespace and table performance. With STMM controlling DBM and DB memory for the most part, many configuration problems have disappeared and STMM does a good job at keeping it that way. So, based on my experience, most performance problems nowadays come down to suboptimal SQL. There are many ways to capture suboptimal SQL and one of them is by using the db2mon tool that comes with Db2. You can use it to augment the MONREPORT reporting module and MON_GET table functions. There is an excellent article written by a member of the Db2 Toronto Lab performance team on the capabilities of db2mon. Check it out you will be glad you did. Here is the link: https://www.idug.org/news/an-introduction-to-db2mon.