Search This Blog

Thursday, July 1, 2010

SAP MaxDB :: Displaying Information About the Log Area

 


Prerequisites

Log on to the database as the database system administrator or as a DBM operator.

The database should be in the ONLINE operational state.

Procedure

Select the database in the explorer tree.

In the context menu of the database, choose Administration.

Open the Log Area tab page.

 

Log Area: Information

   

Property

Description

General

Log settings:

o Log Mode

o Overwrite Mode for the Log Area

o Redo Log Management

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:

o Log pages written with redo log entries

o 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

o Group Commits

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

o 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

Log Volumes

Configured log volumes


No comments:

Post a Comment