Show TOC

VolumeLocate this document in the navigation structure

Use

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

Table 1: Volumes: Types

Type

Main Content

Data Volume

Data

Database Catalog

Undo Log Entries

Log Volume

Redo Log Entries

Table 2: 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

Table 3: Data Volume: Example

Property

Sample Data

Name

DISKD0001

Size

256 MB

Device/File

C:\ProgramData\sdb\globaldata\DEMODB\volumes\data\DISKD0001

Type

FILE

Table 4: 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