Tivoli Header

Administrator's Reference

REDUCE DB (Decrease the Assigned Capacity of the Database)

Use this command to decrease the space that can be used by the database.

Attention:
Do not 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 REDUCE DB command can be initiated while users are accessing the server. Use the QUERY DB command to determine how much you can reduce the assigned capacity of the database.

This command can generate a background process that can be canceled with the CANCEL PROCESS command. If a REDUCE DB background process is canceled, the assigned capacity of the database may be partially reduced. To display information on background processes, use the QUERY PROCESS command.

Privilege Class

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

Syntax

>>-REDuce DB--megabytes----------------------------------------><
 
 

Parameters

megabytes (Required)
Specifies the number of megabytes to be removed from the assigned capacity of the database. This value should be in increments of 4MB. If you do not specify the reduction in 4MB increments, TSM rounds the number to the next 4MB partition.

Examples

Task

Reduce the size of the database by 52MB.

Command:
reduce db 52

Related Commands

Table 226. Commands Related to REDUCE 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.
EXTEND DB Extends usable database storage within the volumes previously allocated for its use.
QUERY DB Displays allocation information about the database.
QUERY DBVOLUME Displays information database volumes.
QUERY PROCESS Displays information about background processes.


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