Use this command to define settings for triggers that determine when and how TSM resolves space shortages in the database and recovery log.
TSM can then allocate more space for your database and recovery log when space utilization reaches a specified value. After allocating more space, TSM automatically extends the database or recovery log to make use of the new space.
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.
Setting the MAXIMUMSIZE parameter does not mean that the database and the recovery log will always be less than the value specified. This value is a threshold for expansion. TSM will not automatically expand the database or the recovery log if either is greater than the maximum size. TSM checks the size and allows expansion if the database or the recovery log is less than the maximum size. TSM only checks the size that results after expansion to ensure that the maximum recovery log size is not exceeded. |
If the server is defined with mirrored copies for the database or recovery log volumes, TSM tries to create new mirrored copies when the utilization percentage is reached. The number of mirrored copies will be the same as the maximum number of mirrors defined for any existing volumes. If sufficient disk space is not available, TSM creates a database or recovery log volume without a mirrored copy.
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--' >-----+-----------------------------+---------------------------> '-EXPansionprefix--=--prefix--' >-----+----------------------------+--------------------------->< '-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. Use space in the /opt/tivoli/tsm/server/bin/ directory.
define spacetrigger db spaceexpansion=100 expansionprefix=/opt/tivoli/tsm/server/bin/
Related Commands
Table 78. 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. |