param_getvolsall 
With this command you can display the data of the database volumes.
Prerequisites
You have the server permission ParamRead.
Structure
param_getvolsall [<vol_mode>]
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>
...
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)