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 db1.dsm.
+--------------------------------------------------------------------------------+ | | |Volume Name Copy Volume Name Copy Volume Name Copy | |(Copy 1) Status (Copy 2) Status (Copy 3) Status | |---------------- ------ ----------- ------ ----------- --- | |L:\WIN32APP\IBM Sync'd L:\WIN32APP\ Sync'd Undef- | | \ADSM\SERVER\D- IBM\SERVER\ ined | | B1.DSM DB3.DSM | +--------------------------------------------------------------------------------+Task 2
Display detailed information on the database volume named DB1.DSM.
+--------------------------------------------------------------------------------+ | | |Volume Name (Copy 1): L:\WIN32APP\IBM\ADSM\SERVER\DB1.DSM | | Copy Status: Sync'd | |Volume Name (Copy 2): L:\WIN32APP\IBM\ADSM\SERVER\DB3.DSM | | 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 160. 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. |