The Management Pack for IBM DB2 collects the metrics listed in the table below, according to IBM DB2 resource kinds.

Download metrics list as .csv file

Resource Kind Resource Group Resource Attribute Attribute Type

DB2 Slow Query

Top N

Average Execution Time

double

DB2 Slow Query

Top N

Average User CPU Time

double

DB2 Slow Query

Top N

Average System CPU Time

double

DB2 Slow Query

Top N

Rows Read

double

DB2 Slow Query

Top N

Rows Written

double

DB2 Slow Query

Top N

Number of Executions

double

DB2 Slow Query

Top N

Query Statement

string

DB2 HADR

HADR

Connect Status

string

DB2 HADR

HADR

Connect Time

string

DB2 HADR

HADR

Heartbeat

double

DB2 HADR

HADR

Local Host

string

DB2 HADR

HADR

Remote Host

string

DB2 HADR

HADR

Remote Instance

string

DB2 HADR

HADR

Remote Service

double

DB2 HADR

HADR

Role

string

DB2 HADR

HADR

State

string

DB2 HADR

HADR

Sync Mode

string

DB2 HADR

HADR

Timeout

double

DB2 Database

Tablespace

Extent Size

double

DB2 Database

Tablespace

Number of Containers

double

DB2 Database

Tablespace

Page Size

double

DB2 Database

Tablespace

Prefetch Size

double

DB2 Database

Tablespace

Tablespace Free Pages

double

DB2 Database

Tablespace

Tablespace State

string

DB2 Database

Tablespace

Tablespace Total Pages

double

DB2 Database

Tablespace

Tablespace Type

string

DB2 Database

Tablespace

Tablespace Usable Pages

double

DB2 Database

Tablespace

Tablespace Used Pages

double

DB2 Database

Tablespace

Tablespace Utilization

double

DB2 Database

Tablespace

Number of Ranges

double

DB2 Database

Tablespace

Bufferpool Identifier

double

DB2 Database

Buffer Pool Performance

Buffer Pool Hit Ratio

double

DB2 Database

Buffer Pool Performance

Logical Data Reads

double

DB2 Database

Buffer Pool Performance

Logical Index Reads

double

DB2 Database

Buffer Pool Performance

Physical Data Reads

double

DB2 Database

Buffer Pool Performance

Physical Index Reads

double

DB2 Database

Buffer Pool Performance

Pool Asynchronous Data Reads

double

DB2 Database

Buffer Pool Performance

Pool Asynchronous Index Reads

double

DB2 Database

Buffer Pool Performance

Pool Asynchronous Data Writes

double

DB2 Database

Buffer Pool Performance

Pool Asynchronous Index Writes

double

DB2 Database

Buffer Pool Performance

Pool Asynchronous Read Time

double

DB2 Database

Buffer Pool Performance

Pool Asynchronous Write Time

double

DB2 Database

Buffer Pool Performance

Pool Data Writes

double

DB2 Database

Buffer Pool Performance

Pool Index Writes

double

DB2 Database

Buffer Pool Performance

Pool Read Time

double

DB2 Database

Buffer Pool Performance

Pool Write Time

double

DB2 Database

Memory Pool

Memory Pool Utilization

double

DB2 Database

Performance

Current Database Size

double

DB2 Database

Performance

Allocated Database Size

double

DB2 Database

Performance

Logical Location of Database

string

DB2 Database

Performance

Pool Asynchronous Writes

double

DB2 Database

Performance

Buffer Pool Data Hit Ratio

double

DB2 Database

Performance

Buffer Pool Hit Ratio

double

DB2 Database

Performance

Buffer Pool Index Hit Ratio

double

DB2 Database

Performance

Logical Data Reads

double

DB2 Database

Performance

Logical Index Reads

double

DB2 Database

Performance

Physical Data Reads

double

DB2 Database

Performance

Physical Index Reads

double

DB2 Database

Performance

Percentage of Applications Waiting on Locks

double

DB2 Database

Performance

Number of Applications Waiting on Locks

double

DB2 Database

Performance

Average Lock Wait Time

double

DB2 Database

Performance

Commit SQL Statements

double

DB2 Database

Performance

Connection Time

string

DB2 Database

Performance

Physical Disk Location of Database

string

DB2 Database

Performance

Number of Deadlocks

double

DB2 Database

Performance

Dynamic SQL Statements

double

DB2 Database

Performance

Failed SQL Statements

double

DB2 Database

Performance

Number of Exclusive Lock Escalations

double

DB2 Database

Performance

Number of Internal Rollbacks

double

DB2 Database

Performance

Number of Internal Deadlock Rollbacks

double

DB2 Database

Performance

Last Reset

double

DB2 Database

Performance

Number of Lock Escalations

double

DB2 Database

Performance

Total Locklist Memory in Use

double

DB2 Database

Performance

Number of Lock Timeouts

double

DB2 Database

Performance

Total Lock Wait Time

double

DB2 Database

Performance

Number of Locks Held

double

DB2 Database

Performance

Number of Lock Waits

double

DB2 Database

Performance

Pool Asynchronous Data Reads

double

DB2 Database

Performance

Pool Asynchronous Data Writes

double

DB2 Database

Performance

Pool Asynchronous Index Reads

double

DB2 Database

Performance

Pool Asynchronous Index Writes

double

DB2 Database

Performance

Pool Asynchronous Read Time

double

DB2 Database

Performance

Pool Asynchronous Write Time

double

DB2 Database

Performance

Pool Synchronous Data Reads

double

DB2 Database

Performance

Pool Synchronous Data Writes

double

DB2 Database

Performance

Pool Synchronous Index Reads

double

DB2 Database

Performance

Pool Synchronous Index Writes

double

DB2 Database

Performance

Pool Data Writes

double

DB2 Database

Performance

Pool Index Writes

double

DB2 Database

Performance

Pool Data Logical Reads

double

DB2 Database

Performance

Pool Data Physical Reads

double

DB2 Database

Performance

Pool Index Logical Reads

double

DB2 Database

Performance

Pool Index Physical Reads

double

DB2 Database

Performance

Pool Read Time

double

DB2 Database

Performance

Pool Write Time

double

DB2 Database

Performance

Rollback SQL Statements

double

DB2 Database

Performance

Static SQL Statements

double

DB2 Database

Performance

Number of Current Connections

double

DB2 Database

Performance

Deadlock Rate

double

DB2 Database

Performance

Commit SQL Statements Rate

double

DB2 Database

Performance

Dynamic SQL Statements Rate

double

DB2 Database

Performance

Exclusive Lock Escalation Rate

double

DB2 Database

Performance

Failed SQL Statements Rate

double

DB2 Database

Performance

Internal Deadlock Rollbacks Rate

double

DB2 Database

Performance

Lock Escalation Rate

double

DB2 Database

Performance

Lock Timeouts Rate

double

DB2 Database

Performance

Rollback SQL Statements Rate

double

DB2 Database

Performance

Static SQL Statements Rate

double

DB2 Database

Performance

Average Data Write Rate

double

DB2 Database

Performance

Average Index Write Rate

double

DB2 Database

Performance

Average Page Read Rate

double

DB2 Database

Performance

Average Page Write Rate

double

DB2 Database

Performance

Logical Data Read Rate

double

DB2 Database

Performance

Logical Index Read Rate

double

DB2 Database

Performance

Physical Data Read Rate

double

DB2 Database

Performance

Physical Index Read Rate

double

DB2 Database

Performance

Synchronous Data Read Rate

double

DB2 Database

Performance

Synchronous Data Write Rate

double

DB2 Database

Performance

Synchronous Index Read Rate

double

DB2 Database

Performance

Synchronous Index Write Rate

double

DB2 Database

Log

Log Space Utilization

double

DB2 Database

Log

Total Log Used

double

DB2 Database

Log

Log Reads

double

DB2 Database

Log

Log Writes

double

DB2 Database

Application Connection

Active Applications

double

DB2 Database

Application Connection

Maximum Active Applications

double

DB2 Database

Application Connection

Applications Connected

double

DB2 Database

Application Connection

Total Connections

double

DB2 Database

Application Connection

Active Local Connections

double

DB2 Database

Application Connection

Active Remote Connections

double

DB2 Database

Application Connection

Local Connections

double

DB2 Database

Application Connection

Remote Connections

double

DB2 Database

Backup

Time of Last Backup

string

DB2 Database

Backup

Days Since Last Backup

double

DB2 Database

Cache Performance

Catalogue Cache Inserts

double

DB2 Database

Cache Performance

Catalogue Cache Lookups

double

DB2 Database

Cache Performance

Catalogue Cache Overflows

double

DB2 Database

Cache Performance

Package Cache Inserts

double

DB2 Database

Cache Performance

Package Cache Lookups

double

DB2 Database

Cache Performance

Package Cache Max Used

double

DB2 Database

Cache Performance

Package Cache Overflows

double

DB2 Database

Cache Performance

Catalog Cache Hit Ratio

double

DB2 Database

Cache Performance

Catalog Cache Heapfull

double

DB2 Database

Cache Performance

Package Cache Hit Ratio

double

DB2 Database

IO Agents

Buffer Pool Victim Page Cleaner Invokes

double

DB2 Database

IO Agents

Buffer Pool Threshold Page Cleaner Invokes

double

DB2 Database

Memory Manager

Total Locklist Memory in Use

double

DB2 Database

Non Buffered IO Performance

Average Direct Write Rate

double

DB2 Database

Non Buffered IO Performance

Average Direct Read Rate

double

DB2 Database

Non Buffered IO Performance

Direct Read Requests

double

DB2 Database

Non Buffered IO Performance

Direct Read Time

double

DB2 Database

Non Buffered IO Performance

Direct Reads

double

DB2 Database

Non Buffered IO Performance

Direct Write Requests

double

DB2 Database

Non Buffered IO Performance

Direct Write Time

double

DB2 Database

Non Buffered IO Performance

Direct Writes

double

DB2 Database

Non Buffered IO Performance

Average Data Read Rate

double

DB2 Database

Sort Heap

Active Sorts

double

DB2 Database

Sort Heap

Post Threshold Hash Joins

double

DB2 Database

Sort Heap

Post Threshold Sorts

double

DB2 Database

Sort Heap

Sort Heap Pages Allocated

double

DB2 Database

Sort Heap

Sort Overflows

double

DB2 Database

Sort Heap

Total Hash Joins

double

DB2 Database

Sort Heap

Total Hash Loops

double

DB2 Database

Sort Heap

Total Hash Join Overflows

double

DB2 Database

Sort Heap

Total Hash Join Small Overflow

double

DB2 Database

Sort Heap

Total Sort Time

double

DB2 Database

Sort Heap

Total Sorts

double

DB2 Database

Sort Heap

Small Overflow Hash Joins to Total Hash Joins Ratio

double

DB2 Database

Sort Heap

Average Post Threshold Joins Rate

double

DB2 Database

Sort Heap

Average Post Threshold Sorts Rate

double

DB2 Database

Sort Heap

Piped Sorts Accepted

double

DB2 Database

Sort Heap

Piped Sorts Requested

double

DB2 Database

Sort Heap

Piped Sorts Rejected

double

DB2 Database

Sort Heap

Average Active Sorts Rate

double

DB2 Database

Sort Heap

Average Hash Join Overflow Rate

double

DB2 Database

Sort Heap

Average Hash Join Rate

double

DB2 Database

Sort Heap

Average Hash Join Small Overflow Rate

double

DB2 Database

Sort Heap

Average Hash Join Small Overflow Ratio

double

DB2 Database

Sort Heap

Average Hash Loops Rate

double

DB2 Database

Sort Heap

Average Piped Sorts Rejected Rate

double

DB2 Database

Sort Heap

Average Sorts Rate

double

DB2 Database

Summary

Status

string

DB2 Database

Agents Connection

Agent Created due to Empty Pool

double

DB2 Database

Agents Connection

Agent Waiting Top

double

DB2 Database

Agents Connection

Agents Registered

double

DB2 Database

Agents Connection

Coordination Agents Top

double

DB2 Database

Agents Connection

Idle Agents

double

DB2 Database

Agents Connection

Pool Agents

double

DB2 Database

Agents Connection

Agents Assignment Rate

double

DB2 Database

Agents Connection

Agent Creation Rate

double

DB2 Database

Agents Connection

Agent Creation to Assignment Ratio

double

DB2 Database

Instance

Startup Time

string

DB2 Database

Instance

Status

string

DB2 Database

Instance

Registered Agents

double

DB2 Database

Instance

Allocated Sort Heap Memory

double

DB2 Database

Instance

Committed Private Memory

double

DB2 Database

Instance

Sort Heap Threshold

double

DB2 Database

Instance

Sort Heap Utilization

double