DB2 10.5 for Linux, UNIX, and Windows

MON_TRANSACTION_LOG_UTILIZATION administrative view - Retrieve log utilization information

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.

Authorization

One of the following authorizations is required:
  • SELECT privilege on the MON_TRANSACTION_LOG_UTILIZATION administrative view
  • CONTROL privilege on the MON_TRANSACTION_LOG_UTILIZATION administrative view
  • DATAACCESS authority
  • DBADM authority
  • SQLADM authority

Default PUBLIC privilege

In a non-restrictive database, SELECT privilege is granted to PUBLIC when the view is automatically created.

Information returned

Table 1. Information returned by the MON_TRANSACTION_LOG_UTILIZATION administrative view
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

Usage notes

For databases that are configured for infinite logging, the values for LOG_UTILIZATION_PERCENT and TOTAL_LOG_AVAILABLE_KB are NULL.