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


>>-QUERY DBSpace-----------------------------------------------><

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.

AIX operating systems Linux operating systems 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.

Linux operating systems 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

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