Tivoli Storage Manager for Sun Solaris Administrator's Reference

UPDATE SPACETRIGGER (Update the Database or Recovery Log Space Triggers)

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

This command does not create new volumes. It does extend the database and recovery log space if available. If it is not available TSM displays a message indicating the amount of new space needed. You can then use these values to allocate the needed space.

See the DEFINE SPACETRIGGER command for more information.

Privilege Class

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

Syntax

>>-UPDate SPACETrigger--+-DB---+---+----------------------+----->
                        '-LOG--'   '-Fullpct--=--percent--'
 
>-----+-----------------------------+--------------------------->
      '-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 of the database or recovery log. When this value is reached, TSM tries to allocate more space. This parameter is optional. You can specify an integer value from 0 to 99. The default is 80. A value of zero (0) disables the space trigger.

SPACEexpansion
Specifies, as a percentage of the current size, the amount by which the database or recovery log can be increased. This parameter is optional. Specify a value 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 that TSM uses to create new database or recovery log files. The prefix name may include one or more directory separator characters, for example, /opt/tivoli/tsm/server/bin/. You can specify up to 250 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. This parameter is optional. When this size is reached, expansion stops, and TSM issues a message. You can specify a value from 9 to 5000 (5GB) for the recovery log, or from 4 to is 9999999MB for the database. A value of zero (0) or omitting this parameter disables checking for maximum size.

Examples

Task 1

Update the setting of the database expansion to 50 percent.

Command:
update spacetrigger db spaceexpansion=50

Task 2

Disable automatic expansion of the recovery log.

Command:
update spacetrigger log spaceexpansion=0
 

Related Commands

Table 317. Commands Related to UPDATE SPACETRIGGER

Command Description
DEFINE DBBACKUPTRIGGER Defines a trigger for automatic TSM database backups.
DEFINE SPACETRIGGER Defines the database or recovery log space trigger.
DELETE SPACETRIGGER Deletes the database or recovery log space trigger.
QUERY SPACETRIGGER Displays information about the database or recovery log space trigger.
SET LOGMODE Sets the mode for saving records in the recovery log.


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