Skip to main content

Techdocs Library > White papers >

Using Table Functions in Db2 LUW - A Db2 Monitoring Approach



Document Author:

Malte Schuenemann


Document ID:

WP102778


Doc. Organization:

Development


Document Revised:

12/06/2019


Product(s) covered:

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.

Db2Monitoring_v1.0.2.pdfDb2Monitoring_v1.0.2.pdf



Classification:

Software

Category:

Performance







O/S:

AIX; HP-UX; Linux; Solaris; Windows

Keywords:

Db2 LUW monitoring

The Techdocs Library
Is this your first visit to Techdocs (the Technical Sales Library)?

Learn more


Techdocs QuickSearch

: