Extend the platform, empower your team.
Remotely collect monitoring metrics from your DB2 databases.
Remotely monitor DB2 databases to complement information collected by 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 and administrative views:
As an alternative to the above 'least-privilege' approach any 1 of the following authorities will provide the required access as well:
As part of the connection process of the SQL datasource, the user must also have the privilege to perform the SELECT opertation on the SYSIBM.SYSDUMMY1 catalog table.
If the database was created with the RESTRICTIVE option you will also need to provide the user with the USAGE privilege on an enabled workload. See here for details.
If you enable the 'top_current_sql' feature set, a query to the MON_CURRENT_SQL view will be made once every 5 minutes and the top 50 currently executing statements (based on elapsed time) will be ingested as log records. Note that currently executing means that a statement must be currently executing at the time this query is run for it to be included. This can give you insight into long running queries in your databases. These logs will be associated with the DB2 Database Instance entity.
Note that as this can result in large amounts of log records being ingested it should be used with caution.
Review the feature set details to see which metrics are 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 supported versions of IBM DB2 for Linux, UNIX, and Windows (LUW) running on AIX, HP-UX, Linux, Solaris, or Windows are supported. DB2 for IBM i is not supported.
Refer to the IBM documentation for details on DB2 end of support dates.
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.
Minimum ActiveGate version required: 1.260
Note: this version has changes to the tables and views that are queried. Review the latest requirements on the Hub page for details on what permissions are needed prior to updating