DSMSERV EXTEND DBSPACE (Increase space for the database)

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 Version 6.3 or later server.

Syntax

(1)
Notes:
  • 1 This parameter applies to AIX® and Linux servers only.
  • 2 This parameter applies only to Windows servers.

Parameters

AIX operating systemsLinux operating systems-u user_name
AIX operating systemsLinux operating systemsSpecifies a user name to switch to before you initialize the server.
AIX operating systemsLinux operating systems-i instance_dir
AIX operating systemsLinux operating systemsSpecifies an instance directory to use. This becomes the current working directory of the server.
Windows operating systems-k key_name
Windows operating systems 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.
Windows operating systemsRestriction: You cannot specify Universal Naming Convention (UNC) paths.
Tip: Specify directories that are the same size as existing directories to ensure a consistent degree of parallelism for database operations. If one or more directories for the database are smaller than the others, they reduce the potential for optimized parallel prefetching and distribution of the database.
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.
AIX operating systemsLinux operating systems

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/stg1
Windows operating systems

Example: 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: