You can use the Database Manager GUI to increase the storage capacity of your data area or log area.
● The maximum number of data volumes you can create is defined in the general database parameter MAXDATAVOLUMES.
● The maximum number of log volumes you can create is defined in the general database parameter MAXLOGVOLUMES.
● You can delete data volumes.
The database instance is in the ONLINE operational state.
If you want to create new volumes, the value of the database parameter MAXDATAVOLUMES or MAXLOGVOLUMES must at least equal the total number of existing volumes plus the new volumes you want to define.
Every time the database instance is started, the system checks that there is enough space available for at least one volume of each type. If there is not, it automatically increases the setting of the appropriate database parameter by 1.
If necessary, change the database parameter MAXDATAVOLUMES or MAXLOGVOLUMES accordingly (see Changing Database Parameters for Volumes). This will enable you to add a volume of the given type a number of times in succession with the database instance in the ONLINE operational state without having to stop the database instance.
...
Select the required database instance in the list of database instances.
Choose Instance ® Configuration ® Volumes.
The system displays all existing volumes of the selected type and their data, as well as the maximum number of volumes still possible according to the parameter value.
Name |
Name of the volume |
Size |
Size of the volume |
Type |
File, raw device, or symbolic link |
Device/File |
Device/path and file name of the volume |
M. Type |
File, raw device, or symbolic link (mirrored volume) |
M. Location |
Path of the mirrored log volume |
1. Under Configuration – Volumes, choose Actions ® New Volume.
2. Define the new volume by specifying the size under Size and the device or path and file name of the volume under Device/File.
3. Choose OK.
4. Select the data volume you want to delete.
5. Choose Actions ® Delete.
6. Confirm that you want to delete this data volume.
See also:
Switching on/off Automatic Extension of the Data Area
Concepts of the Database System, Planning Database Instances