Procedure documentationAdding Log Volumes Locate this document in the navigation structure

 

The log entries of a database are permanently stored in the log volumes (log area). You can increase the size of the log area by adding log volumes. However, you cannot delete log volumes.

If the log area is full, the database stops working. Note that when the log area is full, you first need to carry out a log backup.

Caution Caution

Adding a new log volume will not immediately reduce the filling level of the log area. The system will only use the new log volume after you have carried out a log backup.

End of the caution.

Note Note

To prevent the log area from filling up, you have the following options:

End of the note.

Prerequisites

  • You are logged on to the database as the database system administrator or as a DBM operator with server authorization for accessing database parameters or utility sessions.

    More information: Glossary, Server Permission

  • To create a new log volume, the MaxLogVolumes value must be at least as high as the sum of the number of existing log volumes and the number of log volumes that are to be defined.

    More information: Changing Database Parameters

    Note Note

    Every time the database is started, the system checks whether there is enough space available for at least one volume of each type. If not, it automatically increases the setting of the appropriate database parameter by 1.

    End of the note.

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.

  4. Choose New.... .

  5. Enter the required data.

    Volumes: Properties

    Property

    Description

    Size

    Minimum size: 1000 pages or 8000 KB

    Device/File

    Device/path and file name

    Type

    Type of physical memory

    • FILE (F)

      A volume can be a part of a physical hard disk, a complete physical hard disk, or a storage system consisting of several storage units.

      Can be used on all operating systems

    • LINK (L)

      Can only be used on Unix and Linux

    • RAW (R)

      Raw device

      Can only be used on Unix and Linux

    Log Volume: Example

    Property

    Sample Data

    Name

    DISKL0001

    Size

    50 MB

    Device/File

    C:\ProgramData\sdb\globaldata\DEMODB\volumes\log\DISKL0001

    Type

    FILE

More Information

Concepts of the Database System,