db_addvolume
Use this DBM command to create additional data or log volumes for the database. You can create additional log volumes in existing or in new partitions.
If you are using Microsoft Windows, note that you cannot compress volumes that are files, and that you cannot store them in a compressed operating system directory either.
Adding Data Volumes
Use this command to expand the data area of the database.
If you do not enter a volume specification, then a system default for a volume of type file is determined based on existing volume definitions and used. The automatic extension of the data area will only be successful if the size of the existing volume definition is 1024 pages at a minimum (minimum size of a data volume as per SAP MaxDB version 7.7.04). You can use the Database Manager parameter AutoExtDir to define the directory for this system default volume and, using the Database Manager parameter AutoExtSize, define the size for this system default volume (see: dbm_configset).
Prerequisites
You have the server permission ParamFull or AccessUtility.
Syntax
db_addvolume DATA [<vol_specification>]
<vol_specification> :: = <device_name> <vol_type> <size>
|
Option |
Description |
|---|---|
|
<device_name> |
Name of the device/file If you enter a relative path, it is interpreted as relative to the run directory of the database. |
|
<vol_type> |
Type of the device/file that is to be added Possible values are: F | L | R F: file L: link R: raw device |
|
<size> |
Size of the volume to be added in pages, minimum size is 1024 Pages |
Reply
OK
In the event of errors, see Reply Format.
Adding Log Volumes
Define additional log volumes to expand the log area of the database.
If you execute the DBM command without entering a volume specification, then a system default for a volume of type file based on existing volume definitions is determined and used. It is assigned the partition number of the most recently created log volume, even if this should no longer exist.
You can use the Database Manager parameter AutoExtDirLog to define the directory for this system default, and the Database Manager parameter AutoExtSizeLog to define its size (see: dbm_configset).
Also use this DBM command to create additional log volumes with mirror volumes. Use the Database Manager parameter AutoExtDirLogMirror to define the directory for the system default of the mirror volume.
If the database is not yet mirrored, you first need to change the log mode of the database and then change the volume parameters (see: param_addvolume) to create mirror volumes for existing log volumes.
In the event of errors, see Reply Format.
Concepts of the Database System, Log Area, Volumes (Permanent Storage)
Database Administration, Planning the Database