Background documentationparam_addvolume Locate this document in the navigation structure

 

Note 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).

End of the note.

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:

  1. Change the entries for the parameters in the parameter file.

  2. Transfer the corresponding information to the database kernel with an administrative command (see: db_execute).

Caution 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).

End of the caution.

Prerequisites

You have the server authorization ParamFull.

Structure

param_addvolume <vol_no> <vol_mode> <vol_name> <vol_type> <size> [<partition_no>]

Options

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

Result

OK

In the event of errors, see Reply Format.

More Information

Database Administration, Creating and Configuring a Database Instance

Concepts of the Database System, Log Area, Volumes (Permanent Storage)