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 diagram](./c.gif)
>>-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 DBRECOVERYCommand |
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. |