IBM Tivoli Storage Manager, Version 7.1

SET DBRECOVERY (Set the device class for automatic backups)

Use this command to specify the device class and number of data streams to be used for automatic backups.

If you issue the BACKUP DB command, and the device class is not the one that is specified in the SET DBRECOVERY command, a warning message is issued. However, the backup operation continues and is not affected.

Privilege class

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

Syntax

Read syntax diagramSkip visual syntax diagram
>>-SET DBRECOVery--device_class_name---------------------------->

   .-NUMStreams--=--1------.   
>--+-----------------------+-----------------------------------><
   '-NUMStreams--=--number-'   

Parameters

device_class_name (Required)
Specifies the device class to use for database backups.
NUMStreams
Specifies the number of parallel data movement streams to use when backing up the database. The default value is 1, and the maximum number is 4. Increasing this value causes a corresponding increase in the number of database backup sessions to be used and in the number of drives to be used for the device class. A NUMSTREAMS value specified in the BACKUP DB command overrides any value set in the SET DBRECOVERY command. The NUMSTREAMS value is used for all types of database backups.
If a value is specified that is greater than the number of drives available for the device class, the number of available drives are used. The available drives are those defined to the device class by the MOUNTLIMIT parameter or by the number of online drives for the specified device class. The session is displayed in the QUERY SESSION output.
If you increase the number of streams, more volumes are used from the corresponding device class for this operation. Using more volumes might improve the speed of the database backups, but at the cost of more volumes that are not fully used.

Example: Specify a device class for database backups

Specify the DBBACK device class for database backups. Issue the command:
set dbrecovery dbback

Example: Specify a device class and number of streams for database backups

Specify the DBBACK device class for database backups, and specify that the backup is to use two data movement streams. Issue the command:
set dbrecovery dbback numstreams=2

Related commands

Table 1. Commands related to SET DBRECOVERY
Command Description
BACKUP DB Backs up the Tivoli Storage Manager database to sequential access volumes.
QUERY DB Displays allocation information about the database.
QUERY DBSPACE Displays information about the storage space defined for the database.


Feedback