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
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.
define spacetrigger db spaceexpansion=100
Related Commands
Table 64. Commands Related to DEFINE SPACETRIGGER
Command | Description |
---|---|
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. |