Drill down into the performance of your DB2 database by getting to know bufferpool, transaction, log utilization stats and more.
Detect database outages and failures faster by monitoring DB2 database with Site24x7 plugins. Use these key indicators to ensure continuous functioning of your DB2 servers.
This document details how to configure the DB2 plugin and the monitoring metrics for providing in-depth visibility into the performance, availability, and usage stats of IBM DB2 servers.
DB2 performance monitoring metrics:
Use our wide array of metrics and get notified of hazardous errors that require your attention. DB2 monitoring helps to keep track of unexpected trends through our metric graphs and troubleshoot as quickly as possible. Various out-of-the-box metrics we support are:
Number of bufferpools
The bufferpool is a part of the main memory space allocated by the database manager. The purpose of the bufferpool is to cache entries and their attributes. The number_of_bufferpools helps to efficiently optmize the memory used by the database and increase its overall performance
Total logical reads
total_logical_reads is the sum of data, index and XDA logical reads
Total physical reads
total_physical_reads is the sum of physical reads of data, index and XDA
Total hit ratio percentage
The total_hit_ratio_percent is a measure of how often a page access is satisfied without requiring an input/output operation
Data logical/physical reads
The data_logical_reads and data_physical_reads gives the sum of data logical and physical reads respectively in the DB2 server
Data hit ratio percentage
data_hit_ratio_percent is the individual hit ratio percentage specific for data bufferpool
Index logical reads and hit ratio percentage
index_logical_reads gives the index bufferpool logical reads and index_hit_ratio_percent is the index bufferpool hit ratio percentage
XDA logical reads and hit ratio percentage
xda_logical_reads gives the XDA index logical reads and xda_hit_ratio_percent is the XDA hit ratio percentage
How it works?
Log-in to your Site24x7 account. Sign up here if you don't have one.