DSMSERV DISPLAY DBSPACE (Display information about database storage space)
Use this utility to display information about storage space that is defined for the database. The output of this utility is the same as the output of the QUERY DBSPACE command, but you can use this utility when the server is not running.
Syntax
Parameters
-u
user_name- Specifies a user name to switch to before initializing the server.
- -i
instance_dir
- Specifies an instance directory to use. This becomes the current working directory of the
server.
-k key_name- Specifies the name of a Windows registry key that is used to store information about this server. Use this parameter only when there is more than one server on the same system. The default value is SERVER1.
- -o options_file
- Specifies an options file to use.
- -noexpire
- Specifies that expiration processing is suppressed when starting.
- -quiet
- Specifies that messages to the console are suppressed.
Example: Display database space information
Display information about database storage space. See Field descriptions for details about the information shown in the output. Issue the command.dsmserv display dbspace
Location Total Space (MB) Used Space (MB) Free Space (MB)
------------- ---------------- --------------- ---------------
/tsmdb001 46,080.00 20,993.12 25,086.88
/tsmdb002 46,080.00 20,992.15 25,087.85
Location Total Space (MB) Used Space (MB) Free Space (MB)
------------- ---------------- --------------- ---------------
d:\tsm\db001 46,080.00 20,993.12 25,086.88
d:\tsm\db002 46,080.00 20,993.15 25,087.85
Field descriptions
- Location
- The directory or path that is used for storing the database
- Total Space (MB)
- The total number of megabytes in the location
- Used Space (MB)
- The number of megabytes in use in the location
- Free Space (MB)
- The space remaining in the file system where the path is located
- The space
remaining on the drive where the
directory is located