Extend the platform,
empower your team.
Remotely collect monitoring metrics from your DB2 databases.
Extension by DynatraceRemotely monitor DB2 databases where you cannot install an OneAgent.
The monitoring configurations will be assigned to an ActiveGate group. Make sure the group selected contains ActiveGates that can reach the DB2 instances in that monitoring configuration.
The DB2 user must have read access to monitoring table functions. One of the following authorizations is required:
The relevant feature sets must be enabled for the metrics to be collected.
Calculated metrics (prefixed with 'func:') are calculated on the Dynatrace cluster side based on the metrics collected through the extension. Some calculated metrics require metrics from certain feature sets, so if you do not have all feature sets enabled you may encounter errors when attempting to chart them.
One metric event for alerting configuration is included: 'DB2 - Instance Unavailable'. Find this is Settings > Anomaly detection > Metric events and enable it to have availability events created on the database instance entity if no data is collected for 3 out of 5 minute intervals.
IBM DB2 LUW
The DB2 data source supports SSL connections as of ActiveGate version 1.269. Monitoring configurations will need to be updated to enable SSL and connect to the SSL port.
Below is a complete list of the feature sets provided in this version. To ensure a good fit for your needs, individual metrics can be activated and deactivated by your administrator during configuration.
Metric name | Metric key | Description | Unit |
---|---|---|---|
Apps currently connected | db2.appl_cur_cons | Indicates the number of applications that are currently connected to the database. | Count |
Dynamic SQL statements | db2.dynamic_sql_stmts.count | The number of dynamic SQL statements that were attempted. | Count |
Failed SQL statements | db2.failed_sql_stmts.count | The number of SQL statements that were attempted, but failed. | Count |
Total app commits | db2.total_app_commits.count | Total number of commit statements issued by the client application. | Count |
Internal commits | db2.int_commits.count | The total number of commits initiated internally by the database manager. | Count |
App rollbacks | db2.total_app_rollbacks.count | Total number of rollback statements issued by the client application. | Count |
Internal rollbacks | db2.int_rollbacks.count | The total number of rollbacks initiated internally by the database manager. | Count |
CPU time | db2.total_cpu_time.count | The total amount of CPU time used while within the database system. Represents total of both user and system CPU time. | MicroSecond |
Wait time | db2.total_wait_time.count | The total time spent waiting within the database server. | MicroSecond |
Request time | db2.total_rqst_time.count | The total amount of time spent working on requests. | MilliSecond |
Rows returned | db2.rows_returned.count | The number of rows that have been selected and returned to the application. | Count |
Rows read | db2.rows_read.count | The number of rows read from the tables. | Count |
Rows updated | db2.rows_updated.count | This is the number of row updates attempted. | Count |
Rows deleted | db2.rows_deleted.count | This is the number of row deletions attempted. | Count |
Rows inserted | db2.rows_inserted.count | The number of row insertions attempted. | Count |
Lock wait time | db2.lock_wait_time.count | The total elapsed time spent waiting for locks. | MilliSecond |
Deadlocks | db2.deadlocks.count | The total number of deadlocks that have occurred. | Count |
Lock timeouts | db2.lock_timeouts.count | The number of times that a request to lock an object timed out instead of being granted. | Count |
Buffer pool data writes | db2.pool_data_writes.count | The number of times a buffer pool data page was physically written to disk. | Count |
Buffer pool index writes | db2.pool_index_writes.count | Indicates the number of times a buffer pool index page was physically written to disk. | Count |
Buffer pool XDA writes | db2.pool_xda_writes.count | Indicates the number of times a buffer pool data page for an XML storage object (XDA) was physically written to disk. | Count |
Local buffer pool index pages found | db2.pool_index_lbp_pages_found.count | Indicates the number of index pages which have been synchronously read by agents and asynchronously read by prefetchers from the local buffer pool (logical) for regular and large table spaces. | Count |
Async local buffer pool index pages found | db2.pool_async_index_lbp_pages_found.count | The number of times an index page was present in the local buffer pool when a prefetcher attempted to access it. | Count |
Buffer pool index logical reads | db2.pool_index_l_reads.count | Indicates the number of index pages which have been synchronously read by agents from the buffer pool (logical) for regular and large table spaces. | Count |
Buffer pool temp index logical reads | db2.pool_temp_index_l_reads.count | Indicates the number of index pages which have been requested from the buffer pool (logical) for temporary table spaces. | Count |
Local buffer pool data pages found | db2.pool_data_lbp_pages_found.count | Indicates the number of data pages which have been synchronously read by agents and asynchronously read by prefetchers from the local buffer pool (logical) for regular and large table spaces. | Count |
Async local buffer pool data pages found | db2.pool_async_data_lbp_pages_found.count | The number of times a data page was present in the local buffer pool when a prefetcher attempted to access it. | Count |
Buffer pool data logical reads | db2.pool_data_l_reads.count | Indicates the number of data pages which have been synchronously read by agents from the buffer pool (logical) for regular and large table spaces. | Count |
Buffer pool temp data logical reads | db2.pool_temp_data_l_reads.count | Indicates the number of data pages which have been requested from the buffer pool (logical) for temporary table spaces. | Count |
Local buffer pool XDA pages found | db2.pool_xda_lbp_pages_found.count | Indicates the number of data pages for an XML storage object (XDA) which have been synchronously read by agents and asynchronously read by prefetchers from the local buffer pool (logical) for regular and large table spaces. | Count |
Async local buffer pool XDA pages found | db2.pool_async_xda_lbp_pages_found.count | The number of times a data page for an XML storage object (XDA) was requested by a prefetcher from and found in the local buffer pool. | Count |
Buffer pool XDA logical reads | db2.pool_xda_l_reads.count | Indicates the number of data pages for XML storage objects (XDAs) which have been synchronously read by agents from the buffer pool (logical) for regular and large table spaces. | Count |
Buffer pool temp XDA logical reads | db2.pool_temp_xda_l_reads.count | Indicates the number of pages for XML storage object (XDA) data which have been requested from the buffer pool (logical) for temporary table spaces. | Count |
Buffer pool data physical reads | db2.pool_data_p_reads.count | Indicates the number of data pages which have been synchronously read by agents and asynchronously read by prefetchers from the table space containers (physical) for regular and large table spaces. | Count |
Buffer pool index physical reads | db2.pool_index_p_reads.count | Indicates the number of index pages which have been synchronously read by agents and asynchronously read by prefetchers from the table space containers (physical) for regular and large table spaces. | Count |
Buffer pool XDA physical reads | db2.pool_xda_p_reads.count | Indicates the number of data pages for XML storage objects (XDAs) which have been synchronously read by agents and asynchronously read by prefetchers from the table space containers (physical) for regular and large table spaces. | Count |
Buffer pool temp data physical reads | db2.pool_temp_data_p_reads.count | Indicates the number of data pages read in from the table space containers (physical) for temporary table spaces. | Count |
Buffer pool temp index physical reads | db2.pool_temp_index_p_reads.count | Indicates the number of index pages read in from the table space containers (physical) for temporary table spaces. | Count |
Buffer pool temp XDA physical reads | db2.pool_temp_xda_p_reads.count | Indicates the number of pages for XML storage object (XDA) data read in from the table space containers (physical) for temporary table spaces. | Count |
Buffer pool victim page cleaners triggered | db2.pool_drty_pg_steal_clns.count | The number of times a page cleaner was invoked because a synchronous write was needed during the victim buffer replacement for the database. | Count |
Total sorts | db2.total_sorts.count | The total number of sorts that have been executed. | Count |
Metric name | Metric key | Description | Unit |
---|---|---|---|
Log write time | db2.log_write_time.count | The total elapsed time spent by the logger writing log data to the disk. | MilliSecond |
Transaction log used | db2.total_log_used | The total amount of active log space currently used in the database. | Byte |
Transaction log available | db2.total_log_available | The amount of active log space in the database that is not being used by uncommitted transactions. | Byte |
Metric name | Metric key | Description | Unit |
---|---|---|---|
Active connections | db2.active_connections | Current active connections to database. | Count |
Metric name | Metric key | Description | Unit |
---|---|---|---|
Tablespace total pages | db2.tbsp_total_pages | Total number of pages in a table space. | Count |
Tablespace used pages | db2.tbsp_used_pages | The total number of pages that are currently used (not free) in a table space. | Count |