The MON_TRANSACTION_LOG_UTILIZATION administrative view returns information about transaction log utilization for the currently connected database.
A single row is returned for each member.
In a non-restrictive database, SELECT privilege is granted to PUBLIC when the view is automatically created.
Column name | Data type | Description or corresponding monitor element |
---|---|---|
LOG_UTILIZATION_PERCENT | DECIMAL(5,2) | Indicates the percentage of the total log space that is in use. |
TOTAL_LOG_USED_KB | BIGINT | total_log_used - Total log space used. This interface returns the value in KB. |
TOTAL_LOG_AVAILABLE_KB | BIGINT | total_log_available - Total log available. This interface returns the value in KB. |
TOTAL_LOG_USED_TOP_KB | BIGINT | tot_log_used_top - Maximum total log space used. This interface returns the value in KB. |
MEMBER | SMALLINT | member - Database member monitor element |
For databases that are configured for infinite logging, the values for LOG_UTILIZATION_PERCENT and TOTAL_LOG_AVAILABLE_KB are NULL.