The database system saves the data of a database permanently in data volumes (data area). If the data area of the database is full, the database stops working. Therefore, you need to monitor the database fill level and add new data volumes as required.
Note
You can configure the database system to add data volumes automatically as required.
More information: Activating or Deactivating Automatic Extension of the Data Area.
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.
More information: 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 instance 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.
In the context menu of the database, choose Administration.
Open the Data Area tab page.
Choose New.... .
Enter the required data.
Property |
Description |
---|---|
Size |
Minimum size: 1000 pages or 8000 KB |
Device/File |
Device/path and file name |
Type |
Type of physical memory
|
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 |