IBM Db2 インテグレーションのメトリクス
IBM Db2 の監視に使う Datadog の公式インテグレーションです。収集するメトリクスは 49 件あります。
公式の紹介文 (英語)
Monitor table space, buffer pool, and other metrics from your IBM Db2 database.
種別の内訳
- gauge (その時点の値): 26 件
- count (集計間隔内の発生回数): 23 件
メトリクスの一覧
説明は公式の定義の英文をそのまま載せています。
| メトリクス | 種別 | 単位 |
|---|---|---|
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 |
公式ドキュメント
メトリクスの名前と説明は Datadog の公式インテグレーションの定義 (Copyright Datadog, Inc.・BSD-3-Clause) を英文のまま載せています。利用条件の全文は サイトについてにあります。