Health indicators summary

You use health indicators to monitor your database performance. Health indicators include automatic storage utilization, table space utilization, High Availability Disaster Recovery (HADR) monitors, and application concurrency monitors.

The following tables list all health indicators, grouped by category.

Table 1. Database automatic storage utilization health indicators
Name	Identifier	Additional Information
Database Automatic Storage Utilization	db.auto_storage_util	db.auto_storage_util - Database automatic storage utilization health indicator

Table 2. Table space storage health indicators
Name	Identifier	Additional Information
Table Space Automatic Resize Status	ts.ts_auto_resize_status	ts.ts_auto_resize_status - Table space automatic resize status health indicator
Automatic Resize Table Space Utilization	ts.ts_util_auto_resize	ts.ts_util_auto_resize - Automatic resize table space utilization health indicator
Table Space Utilization	ts.ts_util	ts.ts_util - Table Space Utilization health indicator
Table Space Container Utilization	tsc.tscont_util	tsc.tscont_util - Table Space Container Utilization health indicator
Table Space Operational State	ts.ts_op_status	ts.ts_op_status - Table Space Operational State health indicator
Table Space Container Operational State	tsc.tscont_op_status	tsc.tscont_op_status - Table Space Container Operational State health indicator
Table Space Automatic Resize Status	ts.ts_auto_resize_status	ts.ts_auto_resize_status - Table space automatic resize status health indicator

Table 3. Sorting health indicators
Name	Identifier	Additional Information
Private Sort Memory Utilization	db2.sort_privmem_util	db2.sort_privmem_util - Private Sort Memory Utilization health indicator
Shared Sort Memory Utilization	db.sort_shrmem_util	db.sort_shrmem_util - Shared Sort Memory Utilization health indicator
Percentage of Sorts That Overflowed	db.spilled_sorts	db.spilled_sorts - Percentage of Sorts That Overflowed health indicator
Long Term Shared Sort Memory Utilization	db.max_sort_shrmem_util	db.max_sort_shrmem_util - Long Term Shared Sort Memory Utilization health indicator

Table 4. Database manager health indicators
Name	Identifier	Additional Information
Instance Operational State	db2.db2_op_status	db2.db2_op_status - Instance Operational State health indicator
Instance Highest Severity Alert State	-	Instance Highest Severity Alert State health indicator

Table 5. Database health indicators
Name	Identifier	Additional Information
Database Operational State	db.db_op_status	db.db_op_status - Database Operational State health indicator
Database Highest Severity Alert State	-	Database Highest Severity Alert State health indicator

Table 6. Maintenance health indicators
Name	Identifier	Additional Information
Reorganization Required	db.tb_reorg_req	db.tb_reorg_req - Reorganization Required health indicator
Statistics Collection Required health indicator	db.tb_runstats_req	db.tb_runstats_req - Statistics Collection Required health indicator
Database Backup Required	db.db_backup_req	db.db_backup_req - Database Backup Required health indicator

Table 7. High availability disaster recovery health indicators
Name	Identifier	Additional Information
HADR Operational Status health indicator	db.hadr_op_status	db.hadr_op_status - HADR Operational Status health indicator
HADR Log Delay health indicator	db.hadr_delay	db.hadr_delay - HADR Log Delay health indicator

Table 8. Logging health indicators
Name	Identifier	Additional Information
Log Utilization	db.log_util	db.log_util - Log Utilization health indicator
Log File System Utilization	db.log_fs_util	db.log_fs_util - Log File System Utilization health indicator

Table 9. Application concurrency health indicators
Name	Identifier	Additional Information
Deadlock Rate	db.deadlock_rate	db.deadlock_rate - Deadlock Rate health indicator
Lock List Utilization	db.locklist_util	db.locklist_util - Lock List Utilization health indicator
Lock Escalation Rate	db.lock_escal_rate	db.lock_escal_rate - Lock Escalation Rate health indicator
Percentage of Applications Waiting on Locks	db.apps_waiting_locks	db.apps_waiting_locks - Percentage of Applications Waiting on Locks health indicator

Table 10. Package cache, catalog cache, and workspace health indicators
Name	Identifier	Additional Information
Catalog Cache Hit Ratio	db.catcache_hitratio	db.catcache_hitratio - Catalog Cache Hit Ratio health indicator
Package Cache Hit Ratio	db.pkgcache_hitratio	db.pkgcache_hitratio - Package Cache Hit Ratio health indicator
Shared Workspace Hit Ratio	db.shrworkspace_hitratio	db.shrworkspace_hitratio - Shared Workspace Hit Ratio health indicator

Table 11. Memory health indicators
Name	Identifier	Additional Information
Monitor Heap Utilization	db2.mon_heap_util	db2.mon_heap_util - Monitor Heap Utilization health indicator
Database Heap Utilization	db.db_heap_util	db.db_heap_util - Database Heap Utilization health indicator

Table 12. Federated health indicators
Name	Identifier	Additional Information
Nickname Status	db.fed_nicknames_op_status	db.fed_nicknames_op_status - Nickname Status health indicator
Data Source Server Status	db.fed_servers_op_status	db.fed_servers_op_status - Data Source Server Status health indicator