The commands to back up and restore an IBM DB2 database use these variables.

backup Command Variables

Variable

Description

DatabaseName

The name assigned to the database.

UserName

The user name of the administrator.

Password

Password of the administrator.

TS_Name

The name of the specific tablespaces to be backed up.

Location

The directory to store the backup image. If you do not specify a location, the file is stored in the current directory.

NumBuffers

The number of buffers required for the backup operation. If you do not specify the number, by default the system uses two buffers.

BufferSize

The size, in pages, that each buffer uses to perform the backup operation. The size of each buffer used by this operation is based on the value of the backbufsz DB2 Database Manager configuration parameter.

ParallelNum

The number of tablespaces that the system can read in parallel during a backup operation.

INCREMENTAL

The backup operation creates an incremental backup image, which is a copy of all data that were updated since the last successful backup.

restore Command Variables

Variable

Description

DatabaseName

The name assigned to the database.

UserName

The user name of the administrator.

Password

Password of the administrator.

TS_Name

The name of the specific tablespaces to be backed up.

SourceLocation

The directory where the backup image is stored.

Timestamp

Timestamp of a particular backup image, which is used for search during restore. If you do not specify a timestamp, only one backup image is available at the source location.

TargetLocation

The directory to store the restored database, if you are using the backup image to create a new database.

TargetAlias

The alias for the new database.

LogsLocation

The directory where log files for the new database are stored.

NumBuffers

The number of buffers used for the restore operation. If you do not specify the number, by default the system uses two buffers.

BufferSize

The size, in pages, that each buffer uses to perform the restore operation. The size of each buffer used by this operation is based on the value of the backbufsz DB2 Database Manager configuration parameter.

ParallelNum

The number of tablespaces that the system can read in parallel during a restore operation.