Use this command to decrease the space that can be used by the database.
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
Examples
Task
Reduce the size of the database by 52MB.
Related Commands
Table 202. 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. |