Background documentationVolumes (Permanent Storage) Locate this document in the navigation structure

 

The database system permanently stores the data and log entries of a database in the volumes.

Volumes: Types

Type

Main Content

Data Volume

Data

Database Catalog

Undo Log Entries

Log Volume

Redo Log Entries

The data volumes of a database form the data area and the log volumes form the log area.

This graphic is explained in the accompanying text.

Volumes of a Database

When you create a new database, you need to configure at least one data volume and one log volume.

Example (Template Desktop PC / Laptop for a SAP MaxDB Database)

Volume

Number

Size

Path and File Name

Data Volume

1

256 MB

<independent_data_path>\data\DISKD0001

Log Volume

1

50 MB

<independent_data_path>\log\DISKL0001

You cannot change the size of an existing volume. If necessary, you can add more data and log volumes while the database is running. Data volumes can also be deleted.

More information:

For recommendations on the configuration of the volumes, see Planning Databases.

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
Data Volume: Example

Property

Sample Data

Name

DATA0002

Size

256 MB

Device/File

C:\Documents and Settings\All Users\Application Data\sdb\data\demodb\data\DISKD0002

Type

FILE
Log Volume: Example

Property

Sample Data

Name

LOG002

Size

50 MB

Device/File

C:\Documents and Settings\All Users\Application Data\sdb\data\demodb\log\DISKL0002

Type

FILE

More Information

Database Administration