IBM Db2 integration metrics
The official Datadog integration for monitoring IBM Db2. It collects 49 metrics.
Official summary
Monitor table space, buffer pool, and other metrics from your IBM Db2 database.
Metric types
- gauge (value at a point in time): 26
- count (occurrences in the interval): 23
Metrics
Descriptions are the official definitions, unedited.
| Metric | Type | Unit |
|---|---|---|
ibm_db2.The number of applications that are currently connected to the database. | gauge | connection |
ibm_db2.The number of applications for which the database manager is currently processing a request. | gauge | connection |
ibm_db2.The time elapsed since the latest database backup was completed. | gauge | second |
ibm_db2.The percentage of time that the database manager did not need to load a page from disk to service a column-organized table data page request. | gauge | percent |
ibm_db2.The number of column-organized table data pages read from the logical table space containers for temporary, regular, and large table spaces. | count | get |
ibm_db2.The number of column-organized table data pages read from the physical table space containers for temporary, regular, and large table spaces. | count | get |
ibm_db2.The total number of column-organized table data pages read from the table space containers for temporary, regular, and large table spaces. | count | get |
ibm_db2.The percentage of time that the database manager did not need to load a page from disk to service a data page request. | gauge | percent |
ibm_db2.The number of data pages read from the logical table space containers for temporary, regular and large table spaces. | count | get |
ibm_db2.The number of data pages read from the physical table space containers for temporary, regular and large table spaces. | count | get |
ibm_db2.The total number of data pages read from the table space containers for temporary, regular and large table spaces. | count | get |
ibm_db2.The percentage of time that the group database manager did not need to load a page from disk to service a column-organized table data page request. | gauge | percent |
ibm_db2.The percentage of time that the group database manager did not need to load a page from disk to service a data page request. | gauge | percent |
ibm_db2.The percentage of time that the group database manager did not need to load a page from disk to service a page request. | gauge | percent |
ibm_db2.The percentage of time that the group database manager did not need to load a page from disk to service an index page request. | gauge | percent |
ibm_db2.The percentage of XML storage object (XDA) pages that are found in memory (buffer pool) rather than requiring a physical read from disk. | gauge | percent |
ibm_db2.The percentage of time that the database manager did not need to load a page from disk to service a page request. | gauge | percent |
ibm_db2.The percentage of time that the database manager did not need to load a page from disk to service an index page request. | gauge | percent |
ibm_db2.The number of index pages read from the logical table space containers for temporary, regular and large table spaces. | count | get |
ibm_db2.The number of index pages read from the physical table space containers for temporary, regular and large table spaces. | count | get |
ibm_db2.The total number of index pages read from the table space containers for temporary, regular and large table spaces. | count | get |
ibm_db2.The number of pages read from the logical table space containers for temporary, regular and large table spaces. | count | get |
ibm_db2.The number of pages read from the physical table space containers for temporary, regular and large table spaces. | count | get |
ibm_db2.The total number of pages read from the table space containers for temporary, regular and large table spaces. | count | get |
ibm_db2.The percentage of time that the database manager did not need to load a page from disk to service an index page request. | gauge | percent |
ibm_db2.The number of data pages for XML storage objects (XDAs) read from the logical table space containers for temporary, regular and large table spaces. | count | get |
ibm_db2.The number of data pages for XML storage objects (XDAs) read from the physical table space containers for temporary, regular and large table spaces. | count | get |
ibm_db2.The total number of data pages for XML storage objects (XDAs) read from the table space containers for temporary, regular and large table spaces. | count | get |
ibm_db2.The current number of connections. | gauge | connection |
ibm_db2.The highest number of simultaneous connections to the database since the database was activated. | gauge | connection |
ibm_db2.The total number of connections to the database since the first connect, activate, or last reset (coordinator agents). | count | connection |
ibm_db2.The number of locks currently held. | gauge | lock |
ibm_db2.The total number of deadlocks that have occurred. | count | lock |
ibm_db2.The memory pages (4 KiB each) currently in use by the lock list. | gauge | page |
ibm_db2.The number of times that a request to lock an object timed out instead of being granted. | count | lock |
ibm_db2.The average wait time for a lock. | gauge | millisecond |
ibm_db2.The number of agents waiting on a lock. | gauge | lock |
ibm_db2.The disk blocks (4 KiB each) of active log space in the database that is not being used by uncommitted transactions. | gauge | block |
ibm_db2.The number of log pages read from disk by the logger. | count | read |
ibm_db2.The disk blocks (4 KiB each) of active log space currently used in the database. | gauge | block |
ibm_db2.The utilization of active log space as a percentage. | gauge | percent |
ibm_db2.The number of log pages written to disk by the logger. | count | write |
ibm_db2.The total number of rows inserted, updated, or deleted. | count | row |
ibm_db2.The total number of rows that had to be read in order to return result sets. | count | row |
ibm_db2.The total number of rows that have been selected by and returned to applications. | count | row |
ibm_db2.The total size of the table space in bytes. | gauge | byte |
ibm_db2.The total usable size of the table space in bytes. | gauge | byte |
ibm_db2.The total used size of the table space in bytes. | gauge | byte |
ibm_db2.The utilization of the table space as a percentage. | gauge | percent |
Official documentation
Metric names and descriptions are the official Datadog integration definitions (Copyright Datadog, Inc., BSD-3-Clause), reproduced unedited. The full license terms are on the About page.