Tivoli Header

Administrator's Reference

DEFINE SPACETRIGGER (Define the Database or Recovery Log Space Trigger)

Use this command to define settings for triggers that determine when and how TSM resolves space shortages in the database and recovery log.

In the MVS environment, this command will not cause new volumes to be created. It will cause the database and recovery log to be extended if space is available. Event logging allows messages to display the amount of new space that is needed to satisfy the space trigger utilization parameter. You can use these messages to initiate automatic expansion or to complete an allocation job (refer to ANRFMT1 and ANRFMT, sample jobs that are located in the ASAMPLIB library).

Note:
Setting a space trigger does not mean that the percentage used in the database and recovery log will always be less than the value specified with the FULLPCT parameter. TSM checks usage when database and recovery log activity results in a commit. Deleting database volumes and reducing the database does not cause the trigger to activate. Therefore, the utilization percentage can exceed the set value before new volumes are online.

Privilege Class

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

Syntax

                                 .-Fullpct--=--80------.
>>-DEFine SPACETrigger--+-DB--+--+---------------------+-------->
                        '-LOG-'  '-Fullpct--=--percent-'
 
   .-SPACEexpansion--=--20------.
>--+----------------------------+------------------------------->
   '-SPACEexpansion--=--percent-'
 
>--+---------------------------+-------------------------------><
   '-MAXimumsize--=--megabytes-'
 
 

Parameters

DB
Specifies a database space trigger.

LOG
Specifies a recovery log space trigger.

Fullpct
Specifies when TSM automatically notifies you that more space is needed for your database and recovery log. When this value is reached, TSM displays messages ANR4413I and ANR4414I indicating the amount of space needed. This parameter is optional. Specify an integer value from 0 to 99. The default is 80. A value of zero (0) disables the space trigger.

SPACEexpansion
Specifies an increase in the database or recovery log as a percentage of the current size. Specify an integer from 0 to 200. The default is 20. The database must be at least 4MB (5MB file with processing space); the recovery log must be at least 8MB (9MB file with processing space). New database or recovery log volumes must be multiples of 5MB or 9MB respectively. A value of zero (0) disables expansion.

MAXimumsize
Specifies the maximum size, in megabytes, of the database or the recovery log. When this size is reached, expansion stops, and TSM issues a message. This parameter is optional. Specify a value from 9 to 13000 (13GB) for the recovery log, or from 4 to 530000 (530GB) for the database. A value of zero (0) or omitting this parameter disables checking for maximum size. Increasing the size of the recovery log significantly can increase the time required to restart the server, back up the database, and restore the database.

Examples

Task

Set the database space trigger to 80 percent. When the database reaches this value, allocate a volume that is twice the current size.

Command:
 
define spacetrigger db spaceexpansion=100 
 

Related Commands

Table 63. Commands Related to DEFINE SPACETRIGGER

Command Description
DEFINE LOGVOLUME Defines a disk volume to the recovery log.
DELETE SPACETRIGGER Deletes the database or recovery log space trigger.
QUERY SPACETRIGGER Displays information about the database or recovery log space trigger.
UPDATE SPACETRIGGER Changes attributes of the database or recovery log space trigger.


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