Use this command to display information about the directories used by the database to store data.
Any administrator can issue this command.
None.
query dbspace
Location Total Size of Space Used 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 Size of Space Used 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.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.
Command | Description |
---|---|
BACKUP DB | Backs up the Tivoli Storage Manager 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. |