Installation guide

Variables for IBM DB2 Backup and Restore Commands
The commands to back up and restore an IBM DB2 database use these variables.
Table 4-4. 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.
Table 4-5. 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.
vSphere Upgrade
48 VMware, Inc.