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


>>-SET DBRECOVery--device_class_name---------------------------->

   .-NUMStreams--=--1------.  .-COMPress--=--No------.   
>--+-----------------------+--+----------------------+---------->
   '-NUMStreams--=--number-'  '-COMPress--=--+-No--+-'   
                                             '-Yes-'     

   .-PROTECTKeys--=--No------.   
>--+-------------------------+---------------------------------->
   '-PROTECTKeys--=--+-No--+-'   
                     '-Yes-'     

>--+----------------------------+------------------------------><
   '-PASSword--=--password_name-'

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 you back up the database. The default value is 1, and the maximum number is 32. 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 that is 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.

COMPress

Specifies whether volumes are compressed during database backup processing. This parameter is optional. The default value is No. You can specify one of the following values:

No: Specifies that the volumes created by the BACKUP DB command are not compressed.
Yes: Specifies that the volumes created by the BACKUP DB command are compressed.

If you specify the COMPRESS parameter on the BACKUP DB command, it overrides any value that is set in the SET DBRECOVERY command. Otherwise, the value that is set in the SET DBRECOVERY command is used.

Restrictions:

Use caution when you specify the COMPRESS parameter. Using compression during database backups can reduce the size of the backup files. However, compression can increase the time that is required to complete database backup processing.
Do not back up compressed data to tape. If your system environment stores database backups on tape, set the COMPRESS parameter to No in the SET DBRECOVERY and BACKUP DB commands.

PROTECTKeys

Specifies that database backups include a copy of the server master encryption key that is used to encrypt storage pool data. This parameter is optional and only applies if you are using encrypted container storage pools in a cloud environment. The default value is No. You can specify one of the following values:

No: Specifies that database backups do not include a copy of the server master encryption key.
Yes: Specifies that database backups include a copy of the server master encryption key. If you specify this parameter, you must also specify the PASSWORD parameter.

PASSword

Specifies the password that is used to protect the database backup. This parameter only applies if you are using encrypted container storage pools in a cloud environment. If you specify a password for database backup, you must specify the same password on the RESTORE DB command to restore the database. The default is not to protect database backups.

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

Example: Protect storage pool encryption keys in database backups

Encrypt storage pool data by specifying that database backups include a copy of the server master encryption key. Issue the following command:

set dbrecovery dbback protectkeys=yes password=password_name

Related commands

Table 1. Commands related to SET DBRECOVERY
Command	Description
BACKUP DB	Backs up the IBM Spectrum Protect 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.