Administrator's Reference

BACKUP DB (Back Up the Database)

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

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

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.

Type
Specifies the type of backup to run. This parameter is optional. The default is INCREMENTAL. Possible values are:

Incremental
Specifies that you want to run an incremental backup of the TSM database. The maximum number of incremental backups you can run between full backups is 32.

Full
Specifies that you want to run a full backup of the TSM database.

DBSnapshot
Specifies that you want to run a full snapshot database backup. The entire contents of a database are copied and a new snapshot database backup is created without interrupting the existing full and incremental backup series for the database.

VOLumenames

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.

volume_name
Specifies the volumes used to back up the database. Specify multiple volumes by separating the names with commas and no intervening spaces.

FILE:filename
Specifies the name of a file that contains a list of volumes used to back up the database. Each volume name must be on a separate line. Blank lines and comment lines, which begin with an asterisk, are ignored.

For example, to use volumes DB0001, DB0002, and DB0003, create a file named TAPEVOL that contains these lines:

DB0001
DB0002
DB0003

You can then specify the volumes for the command as follows:

VOLUMENAMES=FILE:TAPEVOL

Scratch
Specifies whether scratch volumes can be used for the backup. This parameter is optional. The default is YES. Possible values are:

Yes
Specifies that scratch volumes can be used.

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.

No
Specifies that scratch volumes cannot be used.

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.

Wait
Specifies whether to wait for the server to complete processing this command in the foreground. The default is NO. Possible values are:

No
Specifies that the server processes this command in the background. You can continue with other tasks while the command is being processed. Messages created from the background process are displayed either in the activity log or the server console, depending on where messages are logged.

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.

Yes
Specifies that the server processes this command in the foreground. You wait for the command to complete before continuing with other tasks. The server then displays the output messages to the administrative client when the command completes.
Note:You cannot specify Wait=Yes from the server console.

Examples

Task

Run an incremental backup of the database using a scratch volume. Assume a device class of FILE for the backup.

Command:
backup db devclass=file type=incremental

Related Commands

Table 18. 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.


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