Memory health indicators

db2.mon_heap_util - Monitor Heap Utilization health indicator

This indicator tracks the consumption of the monitor heap memory, based on the memory pool with the ID SQLM_HEAP_MONITOR.

Important: The health monitor, health indicators, and related components have been deprecated in Version 9.7 and might be removed in a future release. Health monitor is not supported in DB2® pureScale® environments. For more information, see Health monitor has been deprecated.

Identifier: db2.mon_heap_util
Health monitor level: Instance
Category: Memory
Type: Upper-bounded threshold-based
Unit: Percentage

The utilization is calculated using the formula:

(db2.pool_cur_size / db2.pool_config_size) * 100

for the Memory Pool Identifier SQLM_HEAP_MONITOR.

Once this percentage reaches the maximum, 100%, monitor operations may fail.

db.db_heap_util - Database Heap Utilization health indicator

This indicator tracks the consumption of the monitor heap memory, based on the memory pool with the ID SQLM_HEAP_DATABASE.

Important: The health monitor, health indicators, and related components have been deprecated in Version 9.7 and might be removed in a future release. Health monitor is not supported in DB2 pureScale environments. For more information, see Health monitor has been deprecated.

Identifier: db.db_heap_util
Health monitor level: Database
Category: Memory
Type: Upper-bounded threshold-based
Unit: Percentage

The utilization is calculated using the formula

(db.pool_cur_size / db.pool_config_size) * 100

for the Memory Pool Identifier SQLM_HEAP_DATABASE.

Once this percentage reaches the maximum, 100%, queries and operations may fail because there is no heap available.