Volumes (Permanent Storage)

Use

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

Table 1: 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.

Figure 1: Volumes of a Database

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

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.

For more information, see

Database Studio,
Database Manager CLI,
- db_addvolume
- db_deletevolume

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

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

Database Administration