IBM DB2 metrics
Database metrics are a comprehensive collection of database workloads and resource usages. The WhaTap monitoring service continuously collects metrics to identify bottlenecks in the database and provides data to help identify the root causes of performance issues.
For more information about other metrics, see the link.
agent_status_summary
This category collects metrics related to agent status every 10 seconds.
Fields
| Field | Type | Unit | Description |
|---|---|---|---|
| inActTime | - | Millisecond(ms) | Amount of time the agent remains inactive |
| isActive | Boolean | - | Whether the agent is active or not |
| isRestart | Boolean | - | Whether the agent was restarted recently (true / false) |
| lastActTime | - | Millisecond(ms) | Last time when the agent was activated (0: Disabled) |
| oid | - | - | Unique IDs for each agent in the project |
| startTime | - | Millisecond(ms) | Timestamp when the agent was started. |
db_db2_counter
-
Collection interval: 5 seconds
-
Statistical data: 5 minutes, 1 hour
Tags
The following lists the tags that are collected in the db_db2_counter category.
| Tag | Description | Remarks |
|---|---|---|
dbType | Database type. | - |
dbVersion | Version of the database in use. | - |
oname | Agent name | Unique value |
Field
The following lists the fields that are collected in the db_db2_counter category.
| Metrics | Description |
|---|---|
active_sessions | Number of active sessions |
col_hit_ratio | Hit ratio of the column cache |
col_logical_reads | Number of logical reads for columns |
col_physical_reads | Number of physical reads for columns |
col_reads_total | Total number of reads for columns |
connect_error | Number of database connection errors |
cpu_cores | Number of CPU cores in use |
cpu_usage_total | Total CPU usage (%) |
data_hit_ratio | Data cache hit ratio |
data_logical_reads | Number of logical reads for data |
data_physical_reads | Number of physical reads for data |
data_reads_total | Total number of reads for data |
direct_read | Number of direct reads |
direct_readtime | Direct reading time |
direct_write | Number of direct writes |
direct_writetime | Direct writing time |
fatal | Number of fatal errors |
count | Total number of specific events or items |
gbp_column_hit_ratio | Hit ratio of the GBP column cache |
gbp_data_hit_ratio | Hit ratio of the GBP data cache |
gbp_index_hit_ratio | Hit ratio of the GBP index cache |
gbp_index_logical_reads | Number of GBP index logical reads |
gbp_index_physical_reads | Number of GBP index physical reads |
gbp_logical_reads | Number of GBP data logical reads |
gbp_physical_reads | Number of GBP data physical reads |
gbp_total_hit_ratio | Hit ratio of the GBP total cache |
gbp_xda_hit_ratio | Hit ratio of the GBP XDA cache |
gbp_xda_logical_reads | Number of GBP XDA logical reads |
gbp_xda_physical_reads | Number of GBP XDA physical reads |
index_hit_ratio | Hit ratio of the index cache |
index_logical_reads | Number of index logical reads |
index_physical_reads | Number of index physical reads |
index_reads_total | Number of all index reads |
lock_wait_sessions | Number of lock waiting sessions |
log_reads | Number of log reads |
log_writes | Number of log writes |
max_appls | Maximum application count |
max_connections | Maximum connection count |
mem | Memory usage |
memory_free | Available memory size (GB) |
memory_swap_free | Available swap memory size (GB) |
memory_swap_total | Total swap memory size (GB) |
memory_total | Total memory size (GB) |
reads_total | Number of all reads |
rows_deleted | Number of deleted rows |
rows_inserted | Number of inserted rows |
rows_modified | Number of modified rows |
rows_read | Number of read rows |
rows_returned | Number of returned rows |
rows_updated | Number of updated rows |
total_commit_count | Number of all commits |
total_hit_ratio | Total cache hit ratio |
total_log_available | Available total log capacity (GB) |
total_log_used | Available total log capacity (GB) |
total_log_used_percent | Used total log ratio (%) |
total_rollback_count | Number of all rollbacks |
total_rollback_time | Total rollback time (ms) |
total_runstats_time | Total statistics execution time |
total_sessions | Number of all sessions |
warning | Number of warnings occurred |
xda_hit_ratio | XDA cache hit ratio |
xda_logical_reads | Number of XDA logical reads |
xda_physical_reads | Number of XDA physical reads |
xda_reads_total | Number of all XDA reads |
XOS-related metrics
The following describes the metrics collected from the XOS agent.
| Metric | Unit | Description |
|---|---|---|
cpu(xos) | pct | CPU utilizationcpu_user + cpu_sys + cpu_iowait |
cpu_idle(xos) | pct | CPU idle time |
cpu_iowait(xos) | pct | CPU's I/O waiting time |
cpu_sys(xos) | pct | CPU's kernel code execution time |
cpu_user(xos) | pct | CPU's user code execution time |
disk_read_bytes(xos) | byte | Number of data blocks read from disk |
disk_reads(xos) | block | Number of buffers read from disk |
disk_write_bytes(xos) | byte | Number of pages written to disk |
disk_writes(xos) | block | Number of buffers written to disk |
mem(xos) | pct | Memory utilization |
mem_available(xos) | MB | Shared memory size |
mem_buffcache(xos) | MB | Amount of memory used by the buff/cache |
mem_free(xos) | MB | Memory not in use |
mem_swapfree(xos) | MB | Unused swap space size Because swap uses disk space, it may cause performance degradation. |
mem_swaptotal(xos) | MB | Total swap size It is used when physical memory is insufficient. |
mem_total(xos) | MB | Total memory size |
mem_used(xos) | MB | Memory size in use |
net_recv_bytes(xos) | byte | Amount of data transmitted over the network |
net_recv_packets(xos) | count | Number of data packets transmitted over the network |
net_send_bytes(xos) | byte | Amount of data transmitted over the network |
net_send_packets(xos) | count | Number of data packets transmitted over the network |