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.

Syntax

Read syntax diagramSkip visual syntax diagram
>>-QUERY DBSpace-----------------------------------------------><

Parameters

None.

Example: Display database storage space information

Display information about database storage space. Issue the command:
query dbspace
AIX operating systemsLinux operating systemsHP-UX operating systemsSun Solaris operating systems
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
Windows operating systems
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.

Field descriptions

Location
Specifies the locations of database directories.
AIX operating systemsHP-UX operating systemsLinux operating systemsSun Solaris operating systemsTotal Size of File System (MB)
AIX operating systemsHP-UX operating systemsLinux operating systemsSun Solaris operating systemsThe total size, in megabytes, of the file system in which the database is located.
Windows operating systemsTotal Size of File System (MB)
Windows operating systemsThe total size, in megabytes, of the drives on which the database is located.
Space Used on File System (MB)
The amount of storage space, in megabytes, that is in use.

AIX operating systemsHP-UX operating systemsLinux operating systemsSun Solaris operating systemsWhen 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.

Linux operating systemsIf 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.

AIX operating systemsHP-UX operating systemsLinux operating systemsSun Solaris operating systemsFree Space Available(MB)
AIX operating systemsHP-UX operating systemsLinux operating systemsSun Solaris operating systemsThe amount of space, in megabytes, that is not in use.
Windows operating systemsFree Space Available (MB)
Windows operating systemsThe amount of space remaining on the drive where the directory is located.

Related commands

Table 1. Commands related to QUERY DBSPACE
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.