Chat now with support
Chat with Support

NetVault Plug-in for DB2 3.3 - User Guide

Setting restore type and other restore options

On the Create Selection Set page, click Edit Plugin Options, and configure the following parameters on the Options tab:

Restore Type: Select one of the following:
Restore all table spaces in the database: To restore all tablespaces in a selected database, select this option.
Restore only table space-level backup images: When performing a restore of one or more selected tablespaces, select this option.
Restore Mode: Select one of the following:
Offline: To prevent other applications and users from connecting to the database during a restore, select this option.
Online: This option is applicable only when performing a tablespace-level restore. It allows other users and applications to connect to the database, and read or modify the data in other tablespaces while the specified tablespaces are being restored.
Incremental Restore: To alert NetVault Backup that a Full Backup being recovered is a portion of an incremental sequence, rather than a standalone Full Backup recovery, select this option. For more information, see Restoring from Incremental Backups and Advanced restore procedures.
Archived Logs Options: Select the applicable options:
Rollforward Archived Logs: To apply the Archived Logs, select this check box.
Soft Recovery: To restore the existing logs to their most up-to-date state, select this option.
Hard Recovery: To restore the logs to the point at which the backup was performed, thus overwriting the existing archived logs files, select this option.
Delete existing logs: To delete all existing log files, select this check box.
Rollforward Only (will not Restore any Files): To perform only a roll-forward recovery without restoring any files, select this check box.
DB2 Buffers Setting: Configure the following parameters:
Number of Buffers: If you are using multiple buffers and I/O channels, specify at least twice as many buffers as channels to ensure that the channels do not have to wait for data. Increasing the number of buffers results in the backup operation completing faster.
Buffer Size: To change the buffer size, enter the value here. The value must be a multiple of the tablespace extent size. The default value for this parameter is 1024 KB.
Number of Sessions: This parameter determines the number of tablespaces that are restored in parallel. Each session is assigned one tablespace at a time until all tablespaces are restored. This parameter is read-only. It is set to the number of sessions used to create the selected backup.

Configuring Destination Details

To restore the data to a different DB2 instance, click the Destination Details tab, and configure the following parameters:

DB2 Instance Name: Enter the name of the instance to which you want to restore the data.
DB2 Instance Admin Account Name: Enter the account name for the DB2 Instance Administrator.
DB2 Instance Admin Password: Enter the password for the configured user account.

Viewing backup information

To view the contents of various backup pieces in the selected backup set, click the Backup Information tab. This tab provides the following details:

Backup done with: The plug-in version number
Backup Type: Full, Incremental, or Delta
Backup Mode: Online or Offline
Backup Includes Tables from the following Databases: This table includes the following columns:
Backup Includes Archived Logs from the following Databases: This table includes the following columns:

Finalizing and submitting the job

The final steps include setting additional options on the Schedule, Source Options, and Advanced Options pages, submitting the job, and monitoring the progress through the Job Status and View Logs pages. These pages and options are common to all NetVault Backup Plug-ins. For more information, see the Quest NetVault Backup Administrator’s Guide.

To save the settings, click Ok, and then click Next.
In Job Name, specify a name for the job if you do not want to use the default setting.
In the Target Client list, select the machine on which you want to restore the data.
TIP: You can also click Choose, and then locate and select the applicable client in the Choose the Target Client dialog box.
Use the Schedule, Source Options, and Advanced Options lists to configure any additional required options.
Click Save or Save & Submit, whichever is applicable.
You can monitor progress on the Job Status page and view the logs on the View Logs page. For more information, see the Quest NetVault Backup Administrator’s Guide.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating