You display the data for the volumes of a database instance.
You have the server authorization ParamRead.
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 |
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>
...
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.
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
...
Concepts of the Database System, Volumes (Permanent Storage)