Background documentationparam_getvolsall Locate this document in the navigation structure

 

With this command you can display the data of the database volumes.

Prerequisites

You have the server permission 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

The data for all volumes of the specified 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 the device/file of the volume

In the event of errors, see Reply Format.

Example

Call Database Manager CLI, log on as the operator OLEG with the password MONDAY, connect to the database DEMODB, and 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)