Procedure documentationDisplaying Information About the Log Area Locate this document in the navigation structure

Prerequisites

  • You are logged on to the database as the database system administrator or as a DBM operator.

  • The database is in the ONLINE operational state.

Procedure

  1. Select the database in the explorer tree.

  2. In the context menu of the database, choose Administration.

  3. Open the Log Area tab page.

    Log Area: Information

    Property

    Description

    General

    Log settings:

    Automatic log backup: Activating or Deactivating Automatic Log Backup

    To change any of these settings, choose the corresponding link.

    Usage

    Free and used space in the log area

    Activities

    Information on logging:

    • Log pages written with redo log entries

    • Wait for Log Writer

      Indicates how often the system had to wait for a commit or rollback for the Log Writer for finish an I/O operation

    • Group Commits

      Indicates how often the system wrote pages that waited for more than one task

    • If the value of Log I/O Queue Overflow is greater than 0, increase the space available for log queues.

      You can configure the number of log queues with the special database parameter LogQueues and the size of the log queues with LogQueueSize.

    Parameters

    Database parameters relevant for log volumes

    More information: Database Administration, Database Parameters

    Log Volumes

    Configured log volumes

More Information

Database Administration, Monitoring Databases

Concepts of the Database System,