Volumes (Permanent Storage)

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 an SAP MaxDB Database)
Volume	Number	Size	Path and File Name
Data Volume	1	256 MB	`C:\ProgramData\sdb\globaldata\DEMODB\volumes\data\DISKD0001`
Log Volume	1	50 MB	`C:\ProgramData\sdb\globaldata\DEMODB\volumes\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:

Database Studio,
Database Manager CLI,
- db_addvolume
- db_deletevolume

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	`DISKD0001`
Size	`256 MB`
Device/File	`C:\ProgramData\sdb\globaldata\DEMODB\volumes\data\DISKD0001`
Type	`FILE`

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

Database Administration