Use this utility to increase space for the database by adding directories for the database to use. This utility performs the same function as the EXTEND DBSPACE command, but you can use it when the server is not running.
Restriction: Redistribution of data and reclaiming
of space as part of an operation to extend database space only works
with DB2 version 9.7 or later table spaces, which are created when
you format a new Tivoli® Storage
Manager version 6.2 or later server. If you upgraded or restored
your Tivoli Storage
Manager server from version 6.1, you cannot redistribute data or reclaim
space. You must use the DSMSERV EXTEND DBSPACE utility
with RECLAIMSTORAGE=NO.
When you add directories to the database, ensure that you follow best practices. For more information, see Configuring the server database directories for optimal performance.
Syntax
>>-DSMSERV -+----------------------+----------------------------> | (1) | '------- -u--user_name-' (2).- -k--Server1--. >--+-------------------------+------+---------------+-----------> | (1) | '- -k--key_name-' '------- -i--instance_dir-' .-,------------. V | >--EXTend DBSpace----db_directory-+-----------------------------> .-RECLAIMstorage--=--Yes-----. >--+----------------------------+------------------------------>< '-RECLAIMstorage--=--+-No--+-' '-Yes-'
Notes:
- This parameter applies to AIX, HP-UX, Linux, and Solaris servers only.
- This parameter applies only to Windows servers.
Parameters
-u user_name- Specifies a user name to switch to before you initialize 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.
- db_directory (Required)
- Specifies the directories for database storage. The directories
must be empty and accessible by the user ID of the database manager.
A directory name must be a fully qualified name and cannot exceed
175 characters in length. Enclose the name in quotation marks if it
contains embedded blanks, an equal sign, or other special characters.
If you are specifying a list of directories for database storage,
the maximum length of the list can be 1400 characters. Restriction: You cannot specify Universal
Naming Convention (UNC) paths.
- RECLAIMstorage
- Specifies whether data is redistributed across newly created database
directories and space is reclaimed from the old storage paths when
you add space to the database. This parameter is optional. The default
value is Yes.
- Yes
- Specifies that data is redistributed so that new directories are
available for immediate use.Important: The redistribution process uses considerable system resources so ensure that you plan ahead. Also, the server might be offline for a while, until the process is completed.
- No
- Specifies that data is not redistributed across database directories and storage space is not reclaimed.
Example: Increase space for the database
Add a directory named stg1 in the tsm_db directory for the database storage space and then redistribute data and reclaim space by issuing the following command: dsmserv extend dbspace /tsm_db/stg1Example: Increase space for the database
Add drive D to the storage space for the database and then redistribute data and reclaim space by issuing the following command: dsmserv extend dbspace D: