RESTORE DATABASE command options
You can restore a DB2 database with either the DB2 RESTORE DATABASE command or with its alternative syntax, RESTORE DB. The DB2 RESTORE DATABASE command restores a database from NetBackup.
Table: DB2 RESTORE command options provides reference information for the command options when used in a NetBackup for DB2 environment.
Table: DB2 RESTORE command options
Option | Purpose |
|---|---|
LOAD NBDB2_Library_Path | Instructs DB2 to use the NBDB2 vendor library when you perform the restore. |
OPEN number SESSIONS | Specifies the number of concurrent data streams used for writing data. Use this option if you have multiple backup devices available or if you have multiplexing enabled in NetBackup. Typically, you should specify the same number of sessions that were used during the backup. You can use fewer sessions, but it may degrade overall restore performance. No benefit exists if you specify more sessions. |
WITH number BUFFERS | Use this option when opening multiple sessions. See OPEN number SESSIONS. The number of buffers must be twice the number of sessions. If you use fewer buffers it can degrade performance or can cause the restore to fail when it reads multiplexed images. |
BUFFER size | Use this option to increase or decrease the buffer size if necessary. Increased size can benefit performance, while decreased size may be necessary if you use numerous buffers. DB2 alters the actual size to be a multiple of the size that is used during the backup. |
WITHOUT PROMPTING | This option is required for unattended restores, and it must be specified in backup scripts that are executed by NetBackup. |
INCREMENTAL | When you use this option, DB2 may not read the entire image from NetBackup media. Consequently, NetBackup logs an error in the activity monitor, which can safely be ignored. |
AUTOMATIC | Use this option to restore a series of full and incremental images. An automated restore coordinates the restoration of a full backup and all associated incremental backups. A single automated restore restores a full backup, an optional cumulative incremental backup, and one or more differential incremental backups. |
HISTORY FILE | When you use this option, DB2 may not read the entire image from NetBackup media. Consequently, NetBackup logs an error in the activity monitor, which can safely be ignored. |
OPTIONS "options-string" |
Specifies the options to be used for the restore operation. The string passes to the vendor support library, for example When the options DB2_POLICY, DB2_COPY_NUMBER, DB2_MEDIA_SERVER, or DB2_RESTORE_PRIORITY are specified, the corresponding environment variables and For more details about these options: If multiple key=value pairs are specified, they are colon delimited. The following example shows colon delimited key=value pairs: DB2 RESTORE ... OPTIONS "DB2_COPY_NUMBER=2:DB2_MEDIA_SERVER=server8" Specifying this option overrides the value that is specified by the VENDOROPT database configuration parameter. |
PARALLELISM n | Specifies the number of buffer manipulators that are to be spawned during the restore operation. DB2 automatically chooses an optimal value for this parameter unless you explicitly enter a value. |