Administrator's Reference

EXTEND DB (Increase the Assigned Capacity of the Database)

Use this command to increase the space that can be used by the database in all allocated database volumes.

Attention: You cannot change the size of an allocated database volume after it has been defined to TSM. If you do, TSM may not initialize correctly and data could be lost.

The EXTEND DB command can be initiated while users are accessing the server. Use the QUERY DB command to determine how much you can increase the assigned capacity of the database.

Privilege Class

To issue this command, you must have system privilege or unrestricted storage privilege.

Syntax

                           .-Wait--=--No------.
>>-EXTend DB--megabytes----+------------------+----------------><
                           '-Wait--=--+-No--+-'
                                      '-Yes-'
 

Parameters

megabytes (Required)
Specifies space, in megabytes, to be added to the assigned capacity of the database. The value should be in increments of 4MB. If you do not specify the extension in 4MB increments, TSM rounds the number to the next 4MB partition.

Wait
Specifies whether to wait for the server to complete processing this command in the foreground. This parameter is optional. The default is NO. Possible values are:

No
Specifies that the server processes this command in the background.

Yes
Specifies that the server processes this command in the foreground
Note:You cannot specify WAIT=YES from the server console.

Examples

Task

Extend the assigned capacity of the database by 52MB.

Command:
extend db 52

Related Commands

Table 119. Commands Related to EXTEND DB

Command Description
CANCEL PROCESS Cancels a background server process.
DEFINE DBCOPY Creates a volume copy of a database volume.
DEFINE DBVOLUME Assigns a volume to be used for database storage.
QUERY DB Displays allocation information about the database.
REDUCE DB Attempts to free up a database volume by reducing usable storage within the volumes defined.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]