QUERY DBSPACE (Display database storage space)
Use this command to display information about the directories used by the database to store data.
Privilege class
Any administrator can issue this command.
Parameters
None.
Example: Display database storage space information
Display information about database storage space. Issue the command:query dbspace
Location Total Space of Used Space on Free Space
File System (MB) File System (MB) Available (MB)
----------------- ---------------- --------------- --------------
/tsmdb001 1,748,800 1,513,191.125 117,804.422
/tsmdb002 1,748,800 1,513,191.125 117,804.422
Location Total Space of Used Space on Free Space
File System (MB) File System (MB) Available (MB)
---------------- ---------------- --------------- --------------
d:\tsm\db001 1,748,800 1,513,191.125 117,804.422
e:\tsm\db002 1,748,800 1,513,191.125 117,804.422
See
Field descriptions for field descriptions.Field descriptions
- Location
- Specifies the locations of database directories.
- Total Space of File System (MB)
- The total amount of space, in megabytes, of the file system in which the database is located.
- Total Space of File System (MB)
- The total amount of space, in megabytes, of the drives on which the database is located.
- Used Space on File System (MB)
- The amount of storage space, in megabytes, that is in use.
When you run the QUERY DBSPACE command, the value in the output might be greater than the value that is obtained by running the df system command. The output from the df system command does not include the amount of space that is reserved for the root user.
If you run the df system command, the default percentage of space that is reserved for the root user is 5%. You can change this default value.
- Free Space Available (MB)
- The amount of space, in megabytes, that is not in use.
- Free Space Available (MB)
- The amount of space remaining on the drive where the directory is located.
Related commands
Command | Description |
---|---|
BACKUP DB | Backs up the IBM Spectrum Protect database to sequential access volumes. |
EXTEND DBSPACE | Adds directories to increase space for use by the database. |
QUERY DB | Displays allocation information about the database. |