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
Display partial information on the database volume named db.1.
+--------------------------------------------------------------------------------+ | | |Volume Name Copy Volume Name Copy Volume Name Copy | |(Copy 1) Status (Copy 2) Status (Copy 3) Status | |---------------- ------ ----------- ------ ----------- --- | |/home/bill/d- Sync'd Undef- Undef- | | smserv/build/d- ined ined | | b.1 | | | +--------------------------------------------------------------------------------+Task 2
Display detailed information on the database volume named DB.1 .
+--------------------------------------------------------------------------------+ | | |Volume Name (Copy 1): /home/bill/dsmserv/build/db.1 | | 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 162. 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. |