Use this command to back up a TSM database to sequential access volumes.
To determine how much additional storage space a backup will require, use the QUERY DB command. That command displays the database pages, in megabytes, that have changed since the last backup.
Privilege Class
To issue this command, you must have system privilege or unrestricted storage privilege.
Syntax
>>-BAckup DB----DEVclass--=--device_class_name------------------> .-Type--=--Incremental-----. >-----+--------------------------+------------------------------> '-Type--=--+-Incremental-+-' +-Full--------+ '-DBSnapshot--' >-----+-----------------------------------------+---------------> | .-,-------------. | | V | | '-VOLumenames--=--+----volume_name---+-+--' '-file_name----------' .-Scratch--=--Yes-----. .-Wait--=--No------. >-----+---------------------+---+------------------+----------->< '-Scratch--=--+-Yes-+-' '-Wait--=--+-No--+-' '-No--' '-Yes-'
Parameters
If all drives for this device class are busy when the backup runs, TSM cancels lower priority operations, such as reclamation, to make a drive available for the backup.
Specifies the volumes used to back up the database. This parameter is optional. However, if you specify SCRATCH=NO, you must specify a list of volumes.
For example, to use volumes DB0001, DB0002, and DB0003, create a file named LISTOF.TAPEVOL that contains these lines:
DB0001 DB0002 DB0003
Then, specify the filename within single quotation marks as follows:
VOLUMENAMES=FILE:'LISTOF.TAPEVOL'
Note: | When the filename is specified within single quotation marks, the value
entered is used as the data set name.
When the filename is specified without quotation marks, then the user prefix associated with the server job is appended to the front of the filename and the resulting string is used as the data set name. For example, the user prefix associated with the server job is ADSMV3 and the filename specified is LIST.TAPES. The data set name will be ADSMV3.LIST.TAPES. |
If you specify SCRATCH=YES and the VOLUMENAMES parameter, TSM uses scratch volumes only if space is unavailable on the specified volumes.
If you do not include a list of volumes by using the VOLUMENAMES parameter, you must either specify SCRATCH=YES or use the default.
If you specify volumes by using the VOLUMENAMES parameter and SCRATCH=NO, the backup will fail if not enough space is available to store the backup data on the specified volumes.
To cancel a background process, use the CANCEL PROCESS command. If a BACKUP DB background process is canceled, some of the database may have already been backed up before the cancellation.
Note: | You cannot specify Wait=Yes from the server console when you issue this command with the MVS MODIFY command. |
Examples
Task
Run an incremental backup of the database using a scratch volume. Assume a device class of FILE for the backup.
Related Commands
Table 17. Commands Related to BACKUP DB
Command | Description |
---|---|
BACKUP DEVCONFIG | Backs up TSM device information to a file. |
BACKUP VOLHISTORY | Records volume history information in external files. |
CANCEL PROCESS | Cancels a background server process. |
DEFINE DBBACKUPTRIGGER | Defines a trigger for automatic TSM database backups. |
DSMSERV RESTORE DB | Restores a TSM database or database volume. |
DELETE VOLHISTORY | Removes sequential volume history information from the volume history file. |
QUERY DB | Displays allocation information about the database. |
QUERY DBBACKUPTRIGGER | Displays information about the database backup trigger. |
QUERY PROCESS | Displays information about background processes. |
QUERY VOLHISTORY | Displays sequential volume history information that has been collected by the server. |
SET LOGMODE | Sets the mode for saving records in the recovery log. |
UPDATE DBBACKUPTRIGGER | Changes one or more attributes of the database backup trigger. |