param_addvolume

Use

Use the DBM command param_addvolume described here only when creating a database instance, when creating a first mirror volume for a database instance, or in consultation with Support.

Extend an existing database instance using the DBM command for adding volumes (see: db_addvolume). Use the DBM command to create mirror volumes only if the database instance is already mirrored; that is, if mirror volumes already exist.

Inconsistencies in the volume settings can damage the database instance.

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)

If this command fails, you must also remove the entries from the parameter file for the database instance.

The system does not check whether there is sufficient disk capacity available to add the volume.

If you create a mirror volume with this DBM command, you must then also set the value of the general database parameter LOG_MIRRORED to YES (see: param_put).

See also:

Database Administration Tutorial, Creating and Configuring a Database Instance

Concepts of the Database System, Volumes (Permanent Storage)

Prerequisites

You have the server authorization ParamFull.

Syntax

param_addvolume <vol_no> <vol_mode> <vol_name> <vol_type> <size>

Options

Option

Description

<vol_no>

Number of the volume

<vol_mode>

Type of volume; possible values are:

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 to be added,

Possible values are:

F: File

L: Link

R: Raw device

<size>

Size of the volume in pages

Reply

OK

In the event of errors, see Reply Format.