Monitoring IBM Db2

The IBM Db2 sensor is automatically deployed and installed after you install the Instana agent.

Supported Versions

Currently, the supported versions for metrics and configuration data are v10.5 and above.
Note: Monitoring of the Db2 instances with DATA_ENCRYPT authentication security mechanism is not supported.

Configuration

NOTE

The local monitoring sensor design is changed to support multiple instances and databases from v1.0.24 onwards. As a result, all the local monitoring configurations needs to be now added under the `local` tag. However, the design is compatible with the existing configuration that you might have been using now for single database instance monitoring, and the single database configuration remains to be supported.
Db2 on docker container using local monitoring is currently not supported on `Windows OS`.

To use a custom port, database, user, password, instance or polling rate, you need to configure the following fields in the agent configuration file <agent_install_dir>/etc/instana/configuration.yaml:

Local

com.instana.plugin.db2:
  local: # multiple local configurations supported
    - instance: 'db2inst1'
      port: '50000'
      user: 'db2inst1'
      password: 'password'
      poll_rate: 5 # seconds
      databases:
        - 'database1'
        - 'database2'
        - 'database3'
        - 'database4'

```### <a href="#note-1"><img src="../../ecosystem/icons2/anchor.svg" width="15px" height="15px"></img></a> NOTE
{: #note-1}

    - Db2 on docker container using local monitoring is currently not supported on `Windows OS`.
    - On Windows OS, the `instance` field should be the owner of the instance, so the configuration can support multiple instances and databases.


### <a href="#remote"><img src="../../ecosystem/icons2/anchor.svg" width="15px" height="15px"></img></a> Remote {: #remote}


```yaml {: codeblock}
com.instana.plugin.db2:
  remote:
    - host: 'host-1'
      port: '50000'
      tabschema: 'SYSTOOLS'
      user: 'db2inst1'
      password: 'db2inst1'
      sslTrustStorePassword: 'password'
      sslTrustStoreLocation: '/path/to/clientTrustStore.jks'
      availabilityZone: 'DB2 Remote Monitoring'
      poll_rate: 5 # seconds
      databases: # multiple databases
        - 'db'
        - 'sample'

The configured remote Db2 instance will then be shown as a separate box in the specified availabilityZone.

SSL/TLS support

For the Instana agent to securely connect to your Db2 server, it needs to be configured here <agent_install_dir>/etc/instana/configuration.yaml:

Local

com.instana.plugin.db2:
  ...
  sslTrustStoreLocation: '/path/to/truststore.jks'
  sslTrustStorePassword: 'trustStorePassword'

Remote

com.instana.plugin.db2:
  remote:
    ...
    sslTrustStoreLocation: '/path/to/truststore.jks'
    sslTrustStorePassword: 'trustStorePassword'

Note: This will enable the Instana agent to connect to Db2 server via SSL. Once it is connected, credentials (user/password) will be used to access the auth-database.

Token Authentication support

JSON Web Tokens (JWT) is a mechanism supported by Db2 for authentication, and is now supported by Db2 sensors from 1.0.27 version onwards. To make the Instana agent to support JWT connection to your Db2 server, you need to configure the <agent_install_dir>/etc/instana/configuration.yaml file as follows:

Local

Instana supports two types of monitoring for Db2 LUW Sensor - Local monitoring and Remote monitoring. For Local monitoring, see the following configuration:

com.instana.plugin.db2:
  local: # multiple local configurations supported
    - instance: 'db2inst1'
      port: '50000'
      user: 'db2inst1'
      password: 'accessTokenHere'
      accessTokenType: 'JWT'
      sslTrustStoreLocation: '/path/to/truststore.jks'
      sslTrustStorePassword: 'trustStorePassword'
      poll_rate: 5 # seconds
      databases: # multiple databases
        - 'db'
        - 'sample'

Remote

Instana supports two types of monitoring for Db2 LUW Sensor - Local monitoring and Remote monitoring. For Remote monitoring, see the following configuration:

com.instana.plugin.db2:
  remote:
    - host: 'host-1'
      port: '50000'
      tabschema: 'SYSTOOLS'
      user: 'db2inst1'
      password: 'accessTokenHere'
      accessTokenType: 'JWT'
      sslTrustStoreLocation: '/path/to/truststore.jks'
      sslTrustStorePassword: 'trustStorePassword'
      availabilityZone: 'DB2 Remote Monitoring'
      poll_rate: 5 # seconds
      databases: # multiple databases
        - 'db'
        - 'sample'

Note

  • For local monitoring, the fields instance and userare required, and for remote monitoring, the user field is required to be provided in the configuration.yaml file, because Instana agent makes use of these values to fetch the right configuration to create unique db2 sensor entities.
  • The access token for authentication is passed to the password entry, and it supports vault configuration just like how it supports with the plain text password.
  • If accessTokenType is enabled, Instana agent assumes the password entry is a token. Therefore, for all authentications other than token, make sure that you either remove or comment out the accessTokenType entry in the configuration.yaml file.

Monitor multiple instances

Monitoring multiple instances is supported for both local and remote monitoring. Here is an example of how you can configure it within configuration.yaml file:

Local

com.instana.plugin.db2:
  local: # multiple local configurations supported
    - instance: 'db2inst1'
      port: '50000'
      user: 'db2inst1'
      password: 'password'
      sslTrustStoreLocation: '/path/to/truststore.jks'
      sslTrustStorePassword: 'trustStorePassword'
      poll_rate: 5 # seconds
      databases:
        - 'database1'
        - 'database2'
        - 'database3'
        - 'database4'
    - instance: 'db2inst2'
      port: '55000'
      user: 'db2inst2'
      password: 'password'
      sslTrustStoreLocation: '/path/to/truststore.jks'
      sslTrustStorePassword: 'trustStorePassword'
      poll_rate: 5 # seconds
      databases:
        - 'database1'
        - 'database2'
        - 'database3'
        - 'database4'

NOTE

- Db2 on docker container using local monitoring is currently not supported on `Windows OS`.
- On Windows OS, the `instance` field should be the owner of the instance, so the configuration can support multiple instances and databases.

Remote

com.instana.plugin.db2:
  remote:
    - host: 'host-1'
      port: '50000'
      tabschema: 'SYSTOOLS'
      user: 'db2inst1'
      password: 'db2inst1'
      sslTrustStorePassword: 'password'
      sslTrustStoreLocation: '/path/to/clientTrustStore.jks'
      availabilityZone: 'DB2 Remote Monitoring'
      poll_rate: 5 # seconds
      databases:
        - 'db'
      ...
    - host: 'host-n'
      port: '50000'
      tabschema: 'SYSTOOLS'
      user: 'db2inst1'
      password: 'db2inst1'
      sslTrustStorePassword: 'password'
      sslTrustStoreLocation: '/path/to/clientTrustStore.jks'
      availabilityZone: 'DB2 Remote Monitoring'
      poll_rate: 5 # seconds
      databases:
        - 'db'
        - 'sample'
      ...

Note: Monitoring multiple instances with process environment variables is not supported.

User permissions

The required Instana user account authorization would be:

  • DATAACCESS authority
  • DBADM authority
  • SQLADM authority

or EXECUTE privilege on the following table functions/views or procedures:

  • MON_GET_CONTAINER
  • MON_GET_TRANSACTION_LOG
  • MON_GET_DATABASE
  • MON_GET_TABLESPACE
  • MON_GET_PKG_CACHE_STMT
  • MON_GET_AGENT
  • MON_GET_HADR
  • MON_GET_CONNECTION
  • MON_GET_PKG_CACHE_STMT
  • MON_GET_UTILITY
  • MON_GET_WORKLOAD
  • MON_GET_INSTANCE
  • MON_TRANSACTION_LOG_UTILIZATION
  • PD_GET_DIAG_HIST
  • PD_GET_LOG_MSGS
  • SYSCAT.INDEXES
  • SYSCAT.TABLES
  • SYSIBMADM.MON_CURRENT_SQL
  • SYSIBMADM.DB_HISTORY
  • SYSIBMADM.DBCFG
  • SYSIBMADM.MON_CONNECTION_SUMMARY
  • SYSIBMADM.MON_DB_SUMMARY
  • SYSIBMADM.MON_LOCKWAITS
  • SYSIBMADM.SNAP_REORG
  • SYSPROC.DB_GET_CFG
  • SYSPROC.DBM_GET_CFG
  • SYSPROC.ENV_GET_INST_INFO

Example:

db2 connect to db

db2 "grant dataaccess, dbadm, sqladm on database to user db2inst1"

db2 "grant execute on FUNCTION SYSPROC.MON_GET_DATABASE to USER db2inst1"

Metrics collection

To view the metrics, select Infrastructure in the sidebar of the Instana User interface, click a specific monitored host, and then you can see a host dashboard with all the collected metrics and monitored processes.

Note: The metrics and details that are collected and displayed on the dashboard are realtime such as lock waits, top queries, top total CPU. The metrics are visible on the dashboard only when the event is active.

Configuration data

  • Process ID
  • Port
  • Version
  • Start time / Up time

Performance metrics

Database

Metric Description Granularity
Connections The total number of connections on the server and is collected from the MON_GET_DATABASE. 5 seconds
Status The current status of the database from table MON_GET_DATABASE. 5 seconds
Rows read The number of rows read from the table and is collected from the MON_GET_DATABASE. 5 seconds
Rows returned The number of rows that have been selected and returned to the application and is collected from the MON_GET_DATABASE. 5 seconds
Commits Total number of commit statements issued by the client application and is collected from the MON_GET_DATABASE. 5 seconds
Rollbacks Total number of rollback statements issued by the client application and is collected from the MON_GET_DATABASE. 5 seconds
SELECTS The number of SQL SELECT statements that were executed and is collected from the MON_GET_DATABASE. 5 seconds
MERGES The number of MERGE statements that were executed and is collected from the MON_GET_DATABASE. 5 seconds
DDLS The number of SQL Data Definition Language (DDL) statements that were executed and is collected from the MON_GET_DATABASE. 5 seconds
UIDS The number of UPDATE, INSERT, MERGE and DELETE statements that were executed and is collected from the MON_GET_DATABASE. 5 seconds
XQUERIES The number of XQuery statements executed for an application or database and is collected from the MON_GET_DATABASE. 5 seconds
Queries - Static The number of static SQL statements that were attempted and is collected from the MON_GET_DATABASE. 5 seconds
Queries - Dynamic The number of dynamic SQL statements that were attempted and is collected from the MON_GET_DATABASE. 5 seconds
Queries - Failed The number of SQL statements that were attempted, but failed and is collected from the MON_GET_DATABASE. 5 seconds
Buffer Pool Data Pages - Physical Writes The number of times a buffer pool data page was physically written to disk and is collected from the MON_GET_DATABASE. 5 seconds
Buffer Pool Data Pages - Physical Reads The number of data pages read in from the table space containers (physical) for regular and large table spaces and is collected from the MON_GET_DATABASE. 5 seconds
Buffer Pool Data Pages - Logical Reads The number of data pages which have been requested from the buffer pool (logical) for regular and large table spaces and is collected from the MON_GET_DATABASE. 5 seconds
Buffer Pool Data Pages - Temp Physical Reads The number of index pages read in from the table space containers (physical) for temporary table spaces and is collected from the MON_GET_DATABASE. 5 seconds
Buffer Pool Data Pages - Temp Logical Reads The number of data pages which have been requested from the buffer pool (logical) for temporary table spaces and is collected from the MON_GET_DATABASE. 5 seconds
Buffer Pool Index Pages - Physical Writes The number of times a buffer pool index page was physically written to disk and is collected from the MON_GET_DATABASE. 5 seconds
Buffer Pool Index Pages - Physical Reads The number of index pages read in from the table space containers (physical) for regular and large table spaces and is collected from the MON_GET_DATABASE. 5 seconds
Buffer Pool Index Pages - Logical Reads The number of index pages which have been requested from the buffer pool (logical) for regular and large table spaces and is collected from the MON_GET_DATABASE. 5 seconds
Buffer Pool Index Pages - Temp Physical Reads The number of index pages read in from the table space containers (physical) for temporary table spaces and is collected from the MON_GET_DATABASE. 5 seconds
Buffer Pool Index Pages - Temp Logical Reads The number of index pages which have been requested from the buffer pool (logical) for temporary table spaces and is collected from the MON_GET_DATABASE. 5 seconds
Buffer Pool XDA - Physical Writes The number of times a buffer pool data page for an XML storage object (XDA) was physically written to disk and is collected from the MON_GET_DATABASE. 5 seconds
Buffer Pool XDA - Physical Reads The number of data pages for XML storage objects (XDAs) read in from the table space containers (physical) for regular and large table spaces and is collected from the MON_GET_DATABASE. 5 seconds
Buffer Pool XDA - Logical Reads The number of data pages for XML storage objects (XDAs) which have been requested from the buffer pool (logical) for regular and large table spaces and is collected from the MON_GET_DATABASE. 5 seconds
Buffer Pool XDA - Temp Physical Reads The number of pages for XML storage object (XDA) data read in from the table space containers (physical) for temporary table spaces and is collected from the MON_GET_DATABASE. 5 seconds
Buffer Pool XDA - Temp Logical Reads The number of pages for XML storage object (XDA) data which have been requested from the buffer pool (logical) for temporary table spaces and is collected from the MON_GET_DATABASE. 5 seconds
Buffer Pool Time - Read The total amount of time spent reading in data and index pages from the table space containers (physical) for all types of table spaces and is collected from the MON_GET_DATABASE. 5 seconds
Buffer Pool Time - Write Cumulative elapsed time for each asynchronous write to complete and is collected from the MON_GET_DATABASE. 5 seconds
Last Backup The elapsed days since the last full database backup was completed and is collected from the SYSIBMADM.DB_HISTORY table. 30 seconds
Log Space - Available The amount of active log space in the database that is not being used by uncommitted transactions and is collected from the MON_GET_TRANSACTION_LOG. 5 seconds
Log Space - Used The total amount of active log space currently used (in bytes) in the database and is collected from the MON_GET_TRANSACTION_LOG. 5 seconds
Log Space - Secondary Log Used The maximum amount of secondary log space used (in bytes) in the database and is collected from MON_GET_TRANSACTION_LOG. 5 seconds
Log Space - Top Log Used The maximum amount of total log space used (in bytes) in the database from MON_GET_TRANSACTION_LOG. 5 seconds
Log Space - Secondary Logs allocated The total number of secondary log files that are currently being used for the database from MON_GET_TRANSACTION_LOG. 5 seconds
Log Space - Logs Used Percentage The percentage of the total log space that is used by the database and is collected from MON_TRANSACTION_LOG_UTILIZATION table. 5 seconds
Log IO - Reads The number of I/O requests issued by the logger for reading log data from the disk and is collected from the MON_GET_TRANSACTION_LOG. 5 seconds
Log IO - Writes The number of I/O requests issued by the logger for writing log data to the disk and is collected from the MON_GET_TRANSACTION_LOG. 5 seconds
Log IO - Pages The number of I/O requests issued by the logger for writing partial log data to the disk and is collected from MON_GET_TRANSACTION_LOG. 5 seconds
Log IO - Read Time The total elapsed time spent by the logger reading log data from the disk and is collected from MON_GET_TRANSACTION_LOG. 5 seconds
Log IO - write Time The total elapsed time spent by the logger writing log data to the disk and is collected from MON_GET_TRANSACTION_LOG. 5 seconds
Log - Reads The number of log pages read from disk by the logger and is collected from the MON_GET_TRANSACTION_LOG. 5 seconds
Log - Writes The number of log pages written to disk by the logger and is collected from the MON_GET_TRANSACTION_LOG. 5 seconds
Log Buffer - Buffer Full The number of times full log buffer caused agents to wait monitor element and is collected from the MON_GET_TRANSACTION_LOG. 5 seconds
Log Buffer - Data in Buffer The number of Log Data Found In Buffer monitor element and is collected from the MON_GET_TRANSACTION_LOG. 5 seconds
Log Active - Application ID holding oldest trasaction Application handle holding the oldest transaction and is collected from MON_GET_TRANSACTION_LOG. 5 seconds
Log Active - First Active Log The file number of the first active log file and is collected from MON_GET_TRANSACTION_LOG. 5 seconds
Log Active - Last Active Log The file number of the last active log file and is collected from MON_GET_TRANSACTION_LOG. 5 seconds
Log Active - Current Active Log The file number of the active log file the database system is currently writing and is collected from MON_GET_TRANSACTION_LOG. 5 seconds
Log Commits - Committed Disk Reads The number of times the currently committed version of a row was retrieved via a log read from disk and is collected from MON_GET_TRANSACTION_LOG. 5 seconds
Log Commits - Committed Total Reads The total number of times the currently committed version of a row was retrieved from the logs and is collected from MON_GET_TRANSACTION_LOG. 5 seconds
Log Commits - Committed Buffer Reads The total buffer reads and is collected from MON_GET_TRANSACTION_LOG. 5 seconds
Agent Status - Total Agent Status The total number of agents under various status and is collected from the MON_GET_AGENT. 60 seconds
Agent Status - UOW Waiting The number of agents with Routine status and is collected from the MON_GET_AGENT. 60 seconds
Agent Status - UOW Executing The number of agents with executing status and is collected from the MON_GET_AGENT. 60 seconds
Agent Status - Lock Wait The number of agents with Lock status and is collected from the MON_GET_AGENT. 60 seconds
Agent Status - Lock Escalation The number of agents with Lock Escalation status is collected from the MON_GET_AGENT. 60 seconds
Agent Status - Other States The number of agents in Other status and is collected from the MON_GET_AGENT. 60 seconds
DBM Config Usage - Total Connections Current number of connections to database and is collected from the MON_GET_INSTANCE. 30 minutes
DBM Config Usage - Agents Max Number Maximum number of agents that are registered and is collected from the MON_GET_INSTANCE. 30 minutes
DBM Config Usage - Coordinating Agents Max Number Maximum number of coordinating agents that are registered and is collected from the MON_GET_INSTANCE. 30 minutes
DBM Config Usage - Agents Created V/S Agents Reused Agents that are created in the empty pool versus agents from the pool and is collected from the MON_GET_INSTANCE. 30 minutes
Workload(SYSDEFAULTUSERWORKLOAD) - Application Commits The total number of application commits and is collected from the MON_GET_WORKLOAD. 60 seconds
Workload(SYSDEFAULTUSERWORKLOAD) - Application Rollbacks The total number of application rollbacks and is collected from the MON_GET_WORKLOAD. 60 seconds
Workload(SYSDEFAULTUSERWORKLOAD) - Lock Timeouts The number of Lock timeouts and is collected from the MON_GET_WORKLOAD. 60 seconds
Workload(SYSDEFAULTUSERWORKLOAD) - Deadlocks The total number of deadlocks detected and is collected from the MON_GET_WORKLOAD. 60 seconds
Workload(SYSDEFAULTUSERWORKLOAD) - Network Time The sum of TCP/IP send wait time, TCP/IP receive wait time, IPC send wait time, IPC receive wait time and is collected from the MON_GET_WORKLOAD. 60 seconds
Workload(SYSDEFAULTUSERWORKLOAD) - Request Time Total request time and is collected from the MON_GET_WORKLOAD. 60 seconds
Workload(SYSDEFAULTUSERWORKLOAD) - Wait Time Total wait time and is collected from the MON_GET_WORKLOAD. 60 seconds
Workload(SYSDEFAULTUSERWORKLOAD) - IO Time Total IO time and is collected from the MON_GET_WORKLOAD. 60 seconds
Top Queries - Count The total count of queries running more than 100 seconds and is collected from the MON_GET_APPLICATION_HANDLE. 20 seconds
Lock Wait Queries - Count The total count of queries running more than 100 seconds and is collected from the MON_LOCKWAITS. 20 seconds
HADR Log Metrics - Requested Send Buffer Requested socket send buffer size monitor element collected from MON_GET_HADR. 10 minutes
HADR Log Metrics - Actual Send Buffer Actual socket send buffer size monitor element and is collected from MON_GET_HADR. 10 minutes
HADR Log Metrics - Requested Receive Buffer Requested socket receive buffer size monitor element collected from MON_GET_HADR. 10 minutes
HADR Log Metrics - Actual Receive Buffer Actual socket receive buffer size monitor element and is collected from MON_GET_HADR. 10 minutes
HADR Log metrics - Time Since Last Receive Time since last message received monitor element and is collected from MON_GET_HADR. 10 minutes
HADR Log Metrics - Current Logger wait Time Current logger wait time monitor element and is collected from MON_GET_HADR. 10 minutes
Lock Statistics - Lock Escalations The number of times the locks have been escalated from several row locks to a table lock and is collected from MON_GET_DATABASE. 15 minutes
Lock Statistics - Lock List In Use The total amount of lock list memory (in bytes) that is in use and is collected from MON_GET_DATABASE. 15 minutes
Lock Statistics - Active Lock Waits The count of active lock waits and is collected from MON_LOCKWAITS. 15 minutes
Lock Statistics - Average Lock Escalations Per Activity The average number of times that locks have been escalated from several row locks to a table lock and is collected from MON_DB_SUMMARY. 15 minutes
Lock Statistics - Lock List Value The current value of the configuration parameter stored in memory and is collected from SYSIBMADM.DBCFG. 15 minutes
Transaction Performance(Incremental Value) - Index Read Efficiency Index Read Efficiency essentially shows how well indexed a database is for the workload (IREF = Rows Read/ Rows Returned) 15 minutes
Transaction Performance(Incremental Value) - Sync Read Percentage The synchronous read percentage indicates the proportion of read I/O that is completed with synchronous reads from MON_GET_DATABASE. 15 minutes
Transaction Performance(Incremental Value) - Async Write Percentage The asynchronous write percentage is the percentage of all index and data writes that were performed asynchronously by the database manager from MON_GET_DATABASE. 15 minutes
Transaction Performance(Incremental Value) - Sorts Per Transactions The Sorts per transaction is the number sorts that have been executed during each transaction from MON_GET_DATABASE. 15 minutes
Transaction Performance(Incremental Value) - SQLs The total number of STATIC_SQL_STMTS + DYNAMIC_SQL_STMTS from MON_GET_DATABASE. 15 minutes

Top Queries

Metric Description Granularity
Application Handle Application handle from MON_CURRENT_SQL. 20 seconds
Application Name Application name from MON_CURRENT_SQL. 20 seconds
Client Application Name Application name from client information from MON_CURRENT_SQL. 20 seconds
Activity State The current state of activity from MON_CURRENT_SQL. 20 seconds
Activity Type The type of activity from MON_CURRENT_SQL. 20 seconds
Session Authorization ID Session Authorization ID from MON_CURRENT_SQL. 20 seconds
Elapsed Time The time elapsed since this activity began in seconds and is collected from MON_CURRENT_SQL. 20 seconds
Statement Text The SQL statement text from the MON_CURRENT_SQL. 20 seconds

Lock Waits

Metric Description Granularity
Requesting Application Handle Requesting Application handle from SYSIBMADM.MON_LOCKWAITS. 60 seconds
Holding Application Handle Holding Application Handle from SYSIBMADM.MON_LOCKWAITS. 60 seconds
Elapsed Time Lock wait time elapsed from SYSIBMADM.MON_LOCKWAITS in seconds. 60 seconds
Lock Mode Mode of the lock - Table , rows or If the application holding this lock cannot be found, a value of NULL is returned and is collected from SYSIBMADM.MON_LOCKWAITS. 60 seconds
Lock Mode Requested Mode of the lock - Table , rows or If the application holding this lock cannot be found, a value of NULL is returned and is collected from SYSIBMADM.MON_LOCKWAITS. 60 seconds
Lock Mode Requested Lock object type waited on for possible values and is collected from SYSIBMADM.MON_LOCKWAITS. 60 seconds
Requesting Statement Text Requesting application SQL statement and is collected from SYSIBMADM.MON_LOCKWAITS. 60 seconds
Holding Client Accounting Holding client accounting from SYSIBMADM.MON_LOCKWAITS. 60 seconds
Requesting Client Accounting Requesting client accounting from SYSIBMADM.MON_LOCKWAITS. 60 seconds

DB Configurations

Metric Description Granularity
Configuration Parameter Name Configuration parameter name from SYSPROC.DB_GET_CFG. 5 minutes
Value Flags Provides specific information for the configuration parameter current value from SYSPROC.DB_GET_CFG. 5 minutes
Deferred Value Flags Provides specific information for the configuration parameter deferred value from SYSPROC.DB_GET_CFG. 5 minutes
Value The current value of the configuration parameter stored in memory from SYSPROC.DB_GET_CFG. 5 minutes
Deferred Value The value of the configuration parameter on disk from SYSPROC.DB_GET_CFG. 5 minutes

DBM Configurations

Metric Description Granularity
Configuration Parameter Name Configuration parameter name from SYSPROC.DBM_GET_CFG. 30 minutes
Value Flags Provides specific information for the configuration parameter current value from SYSPROC.DBM_GET_CFG. 30 minutes
Deferred Value Flags Provides specific information for the configuration parameter deferred value from SYSPROC.DBM_GET_CFG. 30 minutes
Value The current value of the configuration parameter stored in memory from SYSPROC.DBM_GET_CFG. 30 minutes
Deferred Value The value of the configuration parameter on disk from SYSPROC.DBM_GET_CFG. 30 minutes

Diag Log Entry

Metric Description Granularity
Event Timestamp The time when the entry was logged from PD_GET_LOG_MSGS. 30 minutes
Application ID Application ID monitor element from PD_GET_LOG_MSGS. 30 minutes
Message Severity Message severity: C (critical), E (error), W (warning), I (informational) or NULL (if the message severity could not be determined) from PD_GET_LOG_MSGS. 30 minutes
Message Number The numeric message number for the error or event from PD_GET_LOG_MSGS. 30 minutes
Message The summary of the log message from PD_GET_LOG_MSGS. 30 minutes

Top Total CPU

Metric Description Granularity
Executable ID specifies a unique section of the database package cache from MON_GET_PKG_CACHE_STMT. 60 seconds
% of Total Rows Read Percentage of Total Rows Read from MON_GET_PKG_CACHE_STMT. 60 seconds
% of Total CPU Time Percentage of Total CPU time from MON_GET_PKG_CACHE_STMT. 60 seconds
Total CPU Time Total CPU time from MON_GET_PKG_CACHE_STMT. 60 seconds
Statement Execution Time Time taken for Execution from MON_GET_PKG_CACHE_STMT. 60 seconds
% of Statement Execution Time Percentage of Statement Execution Time from MON_GET_PKG_CACHE_STMT. 60 seconds

Log Disk Wait

Metric Description Granularity
Executable ID specifies a unique section of the database package cache from MON_GET_PKG_CACHE_STMT. 60 seconds
Total activity time Total activity time from MON_GET_PKG_CACHE_STMT. 60 seconds
% of Total activity time Percentage of total activity time from MON_GET_PKG_CACHE_STMT. 60 seconds
Total activity wait time Total activity wait time from MON_GET_PKG_CACHE_STMT. 60 seconds
% of Total Activity wait time Percentage of total activity wait time from MON_GET_PKG_CACHE_STMT. 60 seconds
Log disk wait time Log disk wait time from MON_GET_PKG_CACHE_STMT. 60 seconds
% of Log disk wait time Percentage of log disk wait time from MON_GET_PKG_CACHE_STMT. 60 seconds
Log disk waits total Log disk waits total from MON_GET_PKG_CACHE_STMT. 60 seconds

Runtime Statistics

Metric Description Granularity
Object Name The name of the object to which the event applies from PD_GET_DIAG_HIST. 3 hours
Object Name Qualifier For statistics logging, this is the schema of the table or index from PD_GET_DIAG_HIST. 3 hours
Start Time Start time from PD_GET_DIAG_HIST. 3 hours
End Time End time from PD_GET_DIAG_HIST. 3 hours
Duration Difference between the Start Time and End Time from PD_GET_DIAG_HIST in seconds. 3 hours

DB utilities

Metric Description Granularity
Application Name Application name monitor element from MON_GET_UTILITY. 30 minutes
Application Handle Application handle monitor element from MON_GET_UTILITY. 30 minutes
Utility Operation Type Utility operation type monitor element from MON_GET_UTILITY. 30 minutes
Object Type Type of object from MON_GET_UTILITY. 30 minutes
Utility Start Time Utility start time from MON_GET_UTILITY. 30 minutes
Utility Type Utility type from MON_GET_UTILITY. 30 minutes
Utility Detail Utility detail monitor element from MON_GET_UTILITY. 30 minutes

Unit Of Work(UOW)

Metric Description Granularity
Application Name Application name monitor element from MON_GET_CONNECTION. 5 minutes
Application Handle Application handle monitor element from MON_GET_CONNECTION. 5 minutes
Application ID Application ID monitor element from MON_GET_CONNECTION. 5 minutes
Number of Locks Held The number of locks held monitor element from MON_GET_UNIT_OF_WORK. 5 minutes
Log Space Used UOW Unit of work log space used monitor element from MON_GET_UNIT_OF_WORK. 5 minutes
Client Idle Time Min Client idle wait time monitor element in minutes from MON_GET_UNIT_OF_WORK. 5 minutes
Client App Name Client application name from MON_GET_UNIT_OF_WORK.

REORG

Metric Description Granularity
Table Name Table name monitor element from SNAP_GET_TAB_REORG. 3 hours
Table Schema Table schema name monitor element from SNAP_GET_TAB_REORG. 3 hours
Reorg Status Table reorganize Status monitor element from SNAP_GET_TAB_REORG. 3 hours
Reorg Completion Reorganization completion flag monitor element from SNAP_GET_TAB_REORG. 3 hours
Reorg Start Table Reorganize start time monitor element from SNAP_GET_TAB_REORG. 3 hours
Reorg End Table Reorganize end time monitor element from SNAP_GET_TAB_REORG. 3 hours

Table Space Utilities

Metric Description Granularity
Table Name Table space name monitor element from MON_GET_TABLESPACE. 20 seconds
Total Size Total size of table space from MON_GET_TABLESPACE. 20 seconds
Used Space Total used size of table space from MON_GET_TABLESPACE. 20 seconds
Free Space Total available size of table space from MON_GET_TABLESPACE. 20 seconds
Space Util percentage Utilization of the table space as percentage from MON_GET_TABLESPACE. 20 seconds

HADR General

Metric Description Granularity
Role HADR Role monitor element from MON_GET_HADR. 10 minutes
Replay Type HADR Replication type monitor element from MON_GET_HADR. 10 minutes
Sync Mode HADR Synchronization Mode monitor element from MON_GET_HADR. 10 minutes
Standby ID Standby ID monitor element from MON_GET_HADR. 10 minutes
State HADR State monitor element from MON_GET_HADR. 10 minutes
Connect Time HADR Connect Status Time monitor element from MON_GET_HADR. 10 minutes
HADR Timeout HADR Timeout monitor element from MON_GET_HADR. 10 minutes
HADR Log Gap HADR Log Gap monitor element from MON_GET_HADR. 10 minutes
Connect State HADR Connection Status monitor element from MON_GET_HADR. 10 minutes

HADR Connection Status

Metric Description Granularity
Primary Host Primary Member Host monitor element from MON_GET_HADR. 10 minutes
Primary Instance Primary Instance monitor element from MON_GET_HADR. 10 minutes
Primary Member Primary Member monitor element from MON_GET_HADR. 10 minutes
Standby Host Standby member hostname monitor element from MON_GET_HADR. 10 minutes
Standby Instance Standby Instance monitor element from MON_GET_HADR. 10 minutes
Standby Member Standby member monitor element from MON_GET_HADR. 10 minutes
HeartBeat Interval Heartbeat interval monitor element from MON_GET_HADR. 10 minutes
Peer Wait Limit Peer wait limit monitor element from MON_GET_HADR. 10 minutes

HADR Primary Log Information

Metric Description Granularity
Primary Log Primary log file monitor element from MON_GET_HADR. 10 minutes
Primary Log Page Primary log page monitor element MON_GET_HADR. 10 minutes
Primary Log Position Primary log position monitor element from MON_GET_HADR. 10 minutes
Primary Log Time Primary log time monitor element from MON_GET_HADR. 10 minutes
Log Stream ID Log stream ID monitor element from MON_GET_HADR. 10 minutes
HADR Waits Total Total logger wait time monitor element from MON_GET_HADR. 10 minutes

HADR Secondary Log Information

Metric Description Granularity
Secondary Log Secondary log file monitor element from MON_GET_HADR. 10 minutes
Secondary Log Page Secondary log page monitor element MON_GET_HADR. 10 minutes
Secondary Log Position Secondary log position monitor element from MON_GET_HADR. 10 minutes
Secondary Log Time Secondary log time monitor element from MON_GET_HADR. 10 minutes

Index Catalog View

Metric Description Granularity
Table Name Name of the table on which index is defined from SYSCAT.INDEXES. 24 hours
Index Schema Schema name of the table on which index is defined from SYSCAT.INDEXES. 24 hours
Index Name Name of the Index from SYSCAT.INDEXES. 24 hours
Stats Time Last time that any change was made to the recorded statistics for this index SYSCAT.INDEXES. 24 hours
Last Used Date when the index was last used from SYSCAT.INDEXES. 24 hours

Table Sizes

Metric Description Granularity
Table Name Table name monitor element from ADMIN_GET_TAB_INFO. 24 hours
Card Total number of rows in the table SYSCAT.TABLES. 24 hours
Table Size KB Table Size in KB from ADMIN_GET_TAB_INFO. 24 hours
Table Size MB Table Size in MB from ADMIN_GET_TAB_INFO. 24 hours
Average Row Size Average length of rows from SYSCAT.TABLES. 24 hours

Tables Catalog View

Metric Description Granularity
Table Name Table name from SYSCAT.TABLES. 24 hours
Stats Time Time at which any change was last made to recorded statistics for this object from SYSCAT.TABLES. 24 hours
Volatile To check cardinality of the table from SYSCAT.TABLES. 24 hours
Compression To check value and row compression SYSCAT.TABLES. 24 hours
Card Total number of rows in the table from SYSCAT.TABLES. 24 hours