Tivoli Storage Manager for Windows 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.

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

DB
Specifies a database space trigger.

LOG
Specifies a recovery log space trigger.

Fullpct
Specifies a space utilization percentage when TSM automatically allocates more space for the database or recovery log. 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.

EXPansionprefix
Specifies the prefix name for the files that TSM uses to create new database or recovery log files. The prefix name may include one or more directory separator characters, for example, j:\adsmserv\. Specify up to 200 characters. If you specify an invalid prefix, automatic expansion can fail.

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 5000 (5GB) for the recovery log, or from 4 to 9999999MB for the database. A value of zero (0) or omitting this parameter disables checking for maximum size.

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 j:\adsmserv\ directory.

Command:
 
define spacetrigger db spaceexpansion=100 
expansionprefix=j:\adsmserv\

Related Commands

Table 77. 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.


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