param_getvolsall

Use

You display the data for the volumes of a database instance.

See also:

Concepts of the Database System, Volumes (Permanent Storage)

Prerequisites

You have the server authorization ParamRead.

Syntax

param_getvolsall [<vol_mode>]

<vol_mode>

Mode of the volume,

possible values are: DATA | LOG | MLOG

DATA: data volume

LOG: log volume

MLOG: mirrored log volume

Reply

All the data for the selected volume mode is displayed.

OK

<parameter_name> <value>

<parameter_name> <value>

...

<vol_name> <vol_size> <vol_type> <file_name>

<vol_name> <vol_size> <vol_type> <file_name>

...

Values for the Reply Fields

Field

Description

<parameter_name>

Name of the database parameters relevant for the volume mode specified

<value>

Parameter value

<vol_name>

Name of the volume

<vol_size>

Size of the volume

<vol_type>

Type of volume (such as file, raw device)

<file_name>

Name of device/file of the volume

In the event of errors, see Reply Format.

Example

Call the Database Manager CLI, log on as operator OLEG with password MONDAY, connect to the database instance DEMODB, display the data for all volumes of the type DATA:

>dbmcli –u OLEG,MONDAY –d DEMODB param_getvolsall DATA

OK

MAXDATAVOLUMES                   64

DATA_VOLUME_NAME_0001            32768      F  C:\Documents and Settings\All Users\Application Data\sdb\data\DEMODB\data\DISKD0001

DATA_VOLUME_NAME_0002            32768      F  C:\Documents and Settings\All Users\Application Data\sdb\data\DEMODB\data\DISKD0002

...