Note
Use the DBM command param_addvolume only when creating a database instance, when changing the log mode of the database instance from SINGLE to DUAL, or in consultation with Support.
Extend an existing database instance using the DBM command for adding volumes (see: db_addvolume).
You use this DBM command to change the volume parameters in the database instance parameter file. The new parameter value is registered by the system, and is adopted as the effective value when the database instance is restarted.
You change volume parameters in two steps:
Change the entries for the parameters in the parameter file.
Transfer the corresponding information to the database kernel with an administrative command (see: db_execute).
Caution
If this command fails, you must also remove the entries from the parameter file for the database instance.
No check is made of whether there is sufficient disk capacity available to add the volume.
If you create a mirror volume with this DBM command, you must also set the value of the general database parameter UseMirroredLog to YES (see: param_put).
You have the server authorization ParamFull.
param_addvolume <vol_no> <vol_mode> <vol_name> <vol_type> <size> [<partition_no>]
Option |
Description |
---|---|
<vol_no> |
Number of the volume |
<vol_mode> |
Mode of the volume Possible values are: DATA | LOG | MLOG DATA: data volume, the number of the data volume is assigned by the system as a four-digit number with leading zeros when the volume is created LOG: log volume, the number of the log volume is assigned by the system as a three-digit number with leading zeros when the volume is created MLOG: mirrored log volume |
<vol_name> |
Name of the device/file If you are using Microsoft Windows, note that you must not compress volumes that are files, nor can you store them in a compressed operating system directory. |
<vol_type> |
Type of 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 in pages |
<partition_no> |
Number of the log partition |
Database Administration, Creating and Configuring a Database Instance
Concepts of the Database System, Log Area, Volumes (Permanent Storage)