Tivoli Header

Administrator's Reference

DEFINE DBBACKUPTRIGGER (Define the Database Backup Trigger)

Use this command to specify when TSM backs up the database. A backup occurs when the specified percentage of the assigned capacity of the recovery log is reached. TSM uses the database trigger only if the log mode is set to ROLLFORWARD.

Note:
If the backup fails, TSM waits 60 seconds and then tries again. It continues to retry the backup until it is successful.

Privilege Class

To perform this task, you must have one of the following privilege classes:

Syntax

>>-DEFine DBBackuptrigger--DEVclass--=--device_class_name------->
 
   .-LOGFullpct--=--50------.
>--+------------------------+----------------------------------->
   '-LOGFullpct--=--percent-'
 
>--+------------------------------------+----------------------->
   '-INCRDEVclass--=--device_class_name-'
 
   .-NUMINCremental--=--6------.
>--+---------------------------+-------------------------------><
   '-NUMINCremental--=--number-'
 
 

Parameters

DEVclass (Required)
Specifies the name of the sequential access device class to use for backups.

LOGFullpct
Specifies a recovery log utilization percentage from 1 to 99. When this value is exceeded, TSM backs up the database. This parameter is optional. The default is 50.

INCRDEVclass
Specifies the name of the sequential access device class to use for incremental backups. This parameter is optional. The default is the device class specified with the DEVCLASS parameter.

NUMINCremental
Specifies the maximum number of incremental backups that can be run before a full backup is required. The range is from 0 to 32. A value of 0 specifies that TSM runs only full backups. This parameter is optional. The default is 6.

Each incremental backup, whether run automatically or requested by an administrator, is added to the count of incremental backups run. Each full backup, whether run automatically or requested by an administrator, resets the count for incremental backups to zero.

Examples

Task

Set the database backup trigger to 80 percent. After two incremental backups, do a full backup. Use the FILE device class.

Command:
define dbbackuptrigger devclass=file logfullpct=80 numincremental=2

Related Commands

Table 48. Commands Related to DEFINE DBBACKUPTRIGGER

Command Description
BACKUP DB Backs up the Tivoli Storage Manager database to sequential access volumes.
DEFINE DEVCLASS Defines a device class.
DELETE DBBACKUPTRIGGER Deletes the database backup trigger.
QUERY DBBACKUPTRIGGER Displays information about the database backup trigger.
SET LOGMODE Sets the mode for saving records in the recovery log.
UPDATE DBBACKUPTRIGGER Changes one or more attributes of the database backup trigger.


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