Background documentationparam_getvolsall Locate this document in the navigation structure

 

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

Prerequisites

You have the server authorization ParamRead.

Structure

param_getvolsall [<vol_mode>]

Options

Option

Description

<vol_mode>

Mode of the volume

Possible values are: DATA | LOG | MLOG

DATA: data volume

LOG: log volume

MLOG: mirrored log volume

Result

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

Value

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

...

More Information

Concepts of the Database System, Volumes (Permanent Storage)