Logging health indicators

db.log_util - Log Utilization health indicator

This indicator tracks the total amount of active log space used in bytes in the 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.log_util
Health monitor level: Database
Category: Logging
Type: Upper-bounded threshold-based
Unit: Percentage

Log utilization is measured as the percentage of space consumed, where a high percentage may generate an alert.

The indicator is calculated using the formula:

(db.total_log_used / (db.total_log_used + db.total_log_available)) * 100

The values for the log-related database configuration parameters, shown in the additional information, display the current allocations for logs. The additional information also includes the application id for the application which has the oldest active transaction. This application can be forced to free up log space.

db.log_fs_util - Log File System Utilization health indicator

Log File System Utilization tracks the fullness of the file system on which the transaction logs reside.

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.log_fs_util
Health monitor level: Database
Category: Logging
Type: Upper-bounded threshold-based
Unit: Percentage

The DB2 database system may not be able to create a new log file if there is no room on the file system.

Log utilization is measured as the percentage of space consumed. If the amount of free space in the file system is minimal (that is, there is a high percentage for utilization), an alert may be generated.

The indicator is calculated using the formula: (fs.log_fs_used / fs.log_fs_total)*100 where fs is the file system on which the log resides.

The values for the log-related database configuration parameters, shown in the additional information, display the current allocations for logs. The additional details also shows if user exit is enabled.

If Block on Log Disk Full, shown in the additional details, is set to yes and utilization is at 100%, you should resolve any alerts as soon as possible to limit the impact to applications which cannot commit transactions until the log file is successfully created.