Show TOC

param_addvolumeLocate this document in the navigation structure

Use
Note

Use the DBM command param_addvolume only when creating a database, when changing the log mode of the database from SINGLE to DUAL, or in consultation with technical support.

Extend an existing database using the DBM command for adding volumes (see: db_addvolume).

Use this DBM command to change the volume parameters in the database parameter file. The new parameter value is registered by the system, and is adopted as the effective value when the database is next restarted.

Change the 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

    If this command fails, remove the entries made in the database parameter file.

    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, also set the value of the general database parameter UseMirroredLog to YES (see: param_put).

Prerequisites

You have the server permission ParamFull.

Structure

param_addvolume <vol_no> <vol_mode> <device_name> <vol_type> <size>

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: mirror log volume

<device_name>

Name of the device/file

If you are using Microsoft Windows, note that you must not compress volumes, which are files, nor can you store them in a compressed operating system directory.

<vol_type>

Type of device/file, which is to be added

Possible values are: F | L | R

F: file

L: link

R: raw device

<size>

Size of the volume in pages
Result

OK

In the event of errors, see Reply Format.

Example

There are four log volumes. To add another log volume, enter the following command:

dbmcli on DEMODB> param_addvolume 5 LOG "Log Volume 5" FILE 0

OK

More Information

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