Using Table Functions in Db2 LUW - A Db2 Monitoring Approach
DB2 Universal Database
Abstract: This document describes how to collect monitoring data for a database on Db2 LUWę in a certain time frame. The following key items are main characteristics of the approach described.• The information is collected in iterations. This allows you to monitor the database over acertain time period.• Metrics represented by counter values are displayed as differences, rather than absolute values. This eases the identification of possible pain points within the monitored time frame.• The procedure described runs the data evaluation independently from the data collection. This allows you to perform the investigation in a different, non-severe environment rather than a sensitive production database.• The data can be viewed in a spreadsheet. Key metrics can be graphically visualized. The monitoring method allows you to keep track of changes of Db2 metrics with high granularity across an extended period of time. As an example, see the following chart that shows the total request time vs extended latch waits and extended latch wait time for a single application handle. Publications available so far describe two consecutive data collections and the differences between the considered metrics. This requires detailed knowledge of the problem, and the right point in time to be used for data collections. Examples are the Db2 mon script (https://ibm.ent.box.com/s/iz3ytk28d8wsfg03s1lxwjsl7mifvfmu/file/160446905792) and the article “Tuning and Monitoring Database System Performance” (https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/Wc9a068d7f6a6_4434_aece_0d297ea80ab1/page/Tuning%20and%20Monitoring%20Database%20System%20Performance). This document provides one of countless ways to monitor a Db2 database. We'd like to encourage you to modify and even improve the described approach to fit it into your own monitoring scenarios.