![]() |
![]() |
Use this command to display information about database volumes and volume copies.
Privilege Class
Any administrator can issue this command.
Syntax
.-*-----------. >>-Query DBVolume--+-------------+------------------------------> '-volume_name-' .-Format--=--Standard-----. >--+-------------------------+--------------------------------->< '-Format--=--+-Standard-+-' '-Detailed-'
Parameters
Examples
Task 1
+--------------------------------------------------------------------------------+ | Volume Name Copy Volume Name Copy Volume Name Copy | |(Copy 1) Status (Copy 2) Status (Copy 3) Status | |---------------- ------ ----------- ------ ----------- --- | |HARVEY.PINV Sync'd Sync'd Undef- | | ined | +--------------------------------------------------------------------------------+Task 2
Display detailed information on the database volume named HARVEY.PINV.
+--------------------------------------------------------------------------------+ |Volume Name (Copy 1): HARVEY.PINV | | Copy Status: Sync'd | |Volume Name (Copy 2): | | Copy Status: Undefined | |Volume Name (Copy 3): | | Copy Status: Undefined | |Available Space (MB): 4 | |Allocated Space (MB): 4 | | Free Space (MB): 0 | +--------------------------------------------------------------------------------+
where:
Related Commands
Table 146. Commands Related to QUERY DBVOLUME
Command | Description |
---|---|
DEFINE DBCOPY | Creates a volume copy of a database volume. |
DEFINE DBVOLUME | Assigns a volume to be used for database storage. |
DELETE DBVOLUME | Deletes a volume from the database. |
VARY | Specifies whether a disk volume is available to the server for use. |