Adding or Deleting Data Volumes

Use

The data of a database is permanently stored in the data volumes (data area).

Caution

If the data area of a database is full, the database stops working.

To prevent this from happening, you need to monitor the database fill level and add new data volumes as required. To economically use your available storage space, you can also remove data volumes.

Note that you can configure the database system to add or remove data volumes automatically as required (see Activating or Deactivating the Dynamic Adjustment of the Data Area).

Procedure

Adding Data Volumes

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 (see Glossary, Server Permission).
To create a new data volume, the database parameter value MaxDataVolumes must be at least as high as the sum of the number of existing data volumes and the number of data volumes that are to be defined.

More information: Changing Database Parameters

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 value of the appropriate database parameter by 1.

Procedure

Select the database in the explorer tree.
In the context menu of the database, choose Administration.
Open the Data Area tab page.
Choose New.... .

Enter the required data.

Table 1: 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 2: Data Volume: Example
Property	Sample Data
Name	DISKD0001
Size	256 MB
Device/File	C:\ProgramData\sdb\globaldata\DEMODB\volumes\data\DISKD0001
Type	FILE

Deleting Data Volumes

The system distributes the data from the deleted data volume throughout the remaining data volumes, deletes the data volume, and then releases the resources that were previously in use. Data volumes of the FILE type are deleted from the file system.

Note

The last data volume cannot be deleted.

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 (see Glossary, Server Permission).
The database is in the ONLINE operational state.

Procedure

Select the database in the explorer tree.
In the context menu of the database, choose Administration.
Open the Data Area tab page.
Select the volume.
Choose Delete.... .

More Information

Database Administration, Planning the Database

Concepts of the Database System,