Dynatrace Hub

Extend the platform,
empower your team.

IBM DB2 for LUW (remote monitoring)

Remotely collect monitoring metrics from your DB2 databases.

Extension by Dynatrace

Free trial

The DB2 Overview dashboard showing links to the different entity types and several metrics.

DB2 data being injected into the OneAgent detected host screen when there is an IP address match detected between it and the extension discovered DB2 instance.

The DB2 host entity analysis screen with several metrics of the underlying DB2 instances and links to the instances.

The DB2 instance analysis screen with metrics related to the underlying DB2 member databases and links to them.

The DB2 member analysis screen with metrics about the member including transaction, and sql statement metrics.

The DB2 member analysis screen with metrics about the member including buffer pool, tablespace, and transaction log metrics.

Product information
Release notes

Overview

Remotely monitor DB2 databases where you cannot install an OneAgent.

Get started

Activating the extension

Activate Extension in the Hub by going to:
Extensions → DB2 → Add to environment
Add a new monitoring configuration for every DB2 instance you'd like to monitor

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.

Creating a DB2 user

The DB2 user must have read access to monitoring table functions. One of the following authorizations is required:

EXECUTE privilege on the monitoring routines (depening on feature sets used)
- MON_GET_DATABASE
- MON_GET_TRANSACTION_LOG
- MON_GET_TABLESPACE
- MON_GET_CONNECTION
DATAACCESS authority
DBADM authority
SQLADM authority

Details

Metrics collected

The relevant feature sets must be enabled for the metrics to be collected.

Default

db2.availability - Ability to connect to DB2 instance
db2.db_status - Status of the DB2 database member

Database

db2.appl_cur_cons - Applications connected currently
db2.dynamic_sql_stmts.count - Dynamic SQL statements attempted
db2.failed_sql_stmts.count - Failed statement operations
db2.total_app_commits.count - Total application commits
db2.int_commits.count - Internal commits
db2.total_app_rollbacks.count - Total application rollbacks
db2.int_rollbacks.count - Internal rollbacks
db2.total_cpu_time.count - Total CPU time
db2.total_wait_time.count - Total wait time
db2.total_rqst_time.count - Total request time
db2.rows_returned.count - Rows returned
db2.rows_read.count - Rows read
db2.rows_updated.count - Rows updated
db2.rows_deleted.count - Rows deleted
db2.rows_inserted.count - Rows inserted
db2.lock_wait_time.count - Lock wait time
db2.deadlocks.count - Deadlocks
db2.lock_timeouts.count - Lock timeouts
db2.pool_index_lbp_pages_found.count - Local buffer pool index pages found
db2.pool_async_index_lbp_pages_found.count - Local buffer pool index pages found
db2.pool_index_l_reads.count - Buffer pool index logical reads
db2.pool_temp_index_l_reads.count - Buffer pool temporary index logical reads
db2.pool_data_lbp_pages_found.count - Local buffer pool found data pages
db2.pool_async_data_lbp_pages_found.count - Asynchronous local buffer pool data pages found
db2.pool_data_l_reads.count - Buffer pool data logical reads
db2.pool_temp_data_l_reads.count - Buffer pool temporary data logical reads
db2.pool_xda_lbp_pages_found.count - Local buffer pool XDA data pages found
db2.pool_async_xda_lbp_pages_found.count - Asynchronous local buffer pool XDA data pages found
db2.pool_xda_l_reads.count - Buffer pool XDA data logical reads
db2.pool_temp_xda_l_reads.count - Buffer pool temporary XDA data logical reads
db2.pool_data_p_reads.count - Buffer pool data physical reads
db2.pool_index_p_reads.count - Buffer pool index physical reads
db2.pool_xda_p_reads.count - Buffer pool XDA data physical reads
db2.pool_temp_data_p_reads.count - Buffer pool temporary data physical reads
db2.pool_temp_index_p_reads.count - Buffer pool temporary index physical reads
db2.pool_temp_xda_p_reads.count - Buffer pool temporary XDA data physical reads
db2.pool_drty_pg_steal_clns.count - Buffer pool victim page cleaners triggered
db2.total_sorts.count - Total sorts

Transaction log

db2.log_write_time.count - Log write time
db2.total_log_used - Total log space used
db2.total_log_available - Total log space available

Tablespace

db2.tbsp_total_pages - Total pages in table space
db2.tbsp_used_pages - Used pages in table space

Connections

db2.active_connections - Current connections to the database members

Calculated metrics

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.

func:db2.app_transactions (database) - Number of application transactions executed. Commits and rollbacks.
func:db2.table_reads_per_returned_rows_ratio (database) - Cache usage during transaction reads.
func:db2.lock_wait_per_transaction_ratio (database) - Lock wait time per transaction.
func:db2.lock_fails_per_transaction_ratio (database) - Lock fails (deadlocks and lock timeouts) per transaction.
func:db2.log_flush_time_per_transaction_ratio (database, transaction_log) - The time an agent waits for log records to be flushed to disk.
func:db2.pool_index_page_hits (database) - Index pages usage.
func:db2.pool_data_page_hits (database) - Data pages usage.
func:db2.pool_xda_page_hits (database) - XML storage object (XDA) pages usage.
func:db2.pool_physical_reads_per_transaction_ratio (database) - Pool physical reads per transaction.
func:db2.pool_physical_writes_per_transaction_ratio (database) - Pool physical writes per transaction.
func:db2.pool_dirty_steal_triggers_per_transaction_ratio (database) - Number of ‘dirty steal’ triggers per transaction.
func:db2.sorts_per_transaction_ratio (database) - The amount of sort operations per transaction.
func:db2.all_transactions.count (database) - All transactions including internally initiated commits and rollbacks.
func:db2.response_time (database) - CPU and wait time divided by commits and rollbacks.
func:db2.tbsp_page_utilization (tablespace) - Percentage of tablespace in use by tablespace.
func:db2.total_log_utilization (transaction_log) - Percentage of transaction log space used.

Metric event

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.

Compatibility information

IBM DB2 LUW

FAQ

What if I need to connect using SSL?

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.

Support

Built and supported by Dynatrace

Dynatrace support center

Subscribe to new releases

copy to clipboard

Extension content

Content typeNumber of items included

metric query

screen injections

screen layout

generic relationship

alerts

dashboards

metric metadata

screen properties

generic type

list screen layout

screen entities lists

screen chart groups

Feature sets

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.

Feature setsNumber of metrics included

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

Related to IBM DB2 for LUW (remote monitoring)

ActiveGate

Route traffic, monitor cloud environments, monitor remote technologies with extensions and run synthetic monitors.

Full version history

To have more information on how to install the downloaded package, please follow the instructions on this page.

ReleaseDate

Collects active connection metric
- Requires enabling the 'connections' feature set

Initial GA release
Three feature sets:
- Database
- Transaction logs
- Tablespace
UI Screens for DB2 entities
Overview dashboard
'Availability' metric event

Dynatrace Hub

Build your own app

All (669)Log Management and Analytics Kubernetes Infrastructure Observability Automations Application Observability Application Security Digital Experience Business Analytics

Dynatrace Developer