IBM DB2 supported metrics

Metric NameDescriptionListed in Tab
Type of OSType of OS on which DB is running (Linux/Windows etc.)Hardware
ArchitectureThe OS architectureHardware
Host nameConfigured host name on which DB is presentHardware
AvailabilityActive/Inactive — the database availabilityHardware
Average CPU usage (%)Average CPU usage of the machineHardware
Average memory usage (MB)Average memory usage of the machineHardware
Disk usageDisk space utilizationHardware
CPU usageCPU utilization of the hostHardware
Disk requestDisk I/O request rate in DB2 DatabaseHardware
Memory usageMemory utilizationHardware
Query nameList of queries executed on the DatabaseQuery performance
Total executionCount of executions of each slow queryQuery performance
Execution time (s)Total execution time of each collected queryQuery performance
DatabaseDatabase name where the query ranQuery performance
TimestampLast timestamp of each collected queryQuery performance
Total active connectionsNumber of currently active connectionsConnections
Total active sessionsTotal number of active DB sessionsConnections
Sessions tableTable displaying details of DB sessionsConnections
Insert queries per secondNumber of insert queries executed per secondMetrics
Slow queries per secondNumber of slow queries executed per secondMetrics
Total queriesTotal number of queries executedMetrics
Locks waited per secondNumber of lock waits per secondMetrics
Max connection per secondMaximum number of connections per secondMetrics
Total buffer pool readsTotal number of reads from buffer poolMetrics
Buffer pool cache hit ratioPercentage of reads served from buffer pool (cache hits)Metrics
Transactions per secondNumber of transactions executed per secondMetrics
Buffer pool size per DBBuffer pool size allocated per databaseMetrics
System wait time (ms)Average wait time of system resourcesMetrics
Deadlocks per secondNumber of deadlocks detected per secondMetrics
Total open tablesTotal number of open tables in the databaseMetrics

Visualise IBM DB2 data

  • Once Agent is installed & configured successfully, above metrics can be visualised in IBMDB2 Dashboard.