Chat now with support
Chat mit Support

NetVault Plug-in for DB2 12.0 - 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.
 
* 
NOTE: Increasing the value specified for either option might cause the restore operation to use more memory and more processing time.
•
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.
•
Heap Size: By default, the plug-in uses 4096 pages for Heap Size. If you want to use a different value for the database heap configuration parameter, dbheap, enter it in this field.
This parameter controls the maximum amount of memory allocated for database heap. Because an additional amount is always added to the database heap for critical requirements, the value that you enter represents a portion of the actual amount that is allocated. The unit of measure used by the database heap configuration parameter is in pages, 4 KB. There is one database heap per database. The Heap Size is applied to the databases participating in the restore job whenever a roll-forward recovery of the active or archived logs occurs for that database.
 
* 
IMPORTANT: If you do not want the plug-in to update dbheap, and you want it to use the current dbheap value configured for the database, use the Plug‑in for DB2 configuration parameter to indicate whether the dbheap setting can be updated during the roll-forward phase of a restore job.

To use this configuration parameter, add the following stanza to the “nvdb2.cfg” file. This file is located in <NetVault Backup installation directory>\config on the NetVault Backup Client:

[db2:UpdateDatabaseHeap]
Value=FALSE

If you set the parameter to FALSE, the database heap is not updated by the plug-in during the roll-forward phase, and the value entered in the Heap Size field is ignored.

If you omit the parameter or set it to TRUE, the database heap is updated by the plug-in during the roll-forward phase by using the value entered in the Heap Size field.

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
•
DB2 Version
•
Backup Includes Tables from the following Databases: This table includes the following columns:
•
Database Name
•
Database Alias
•
DB2 Instance
•
DB2 Version ID
•
Backup Timestamp
•
Backup Includes Archived Logs from the following Databases: This table includes the following columns:
•
Database Alias
•
DB2 Instance
•
Archive Log
•
Archived Log Path

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.

1
To save the settings, click Ok, and then click Next.
2
In Job Name, specify a name for the job if you do not want to use the default setting.
Assign a descriptive name that lets you easily identify the job when monitoring its progress. The job name can contain alphanumeric and nonalphanumeric characters, but it cannot contain non-Latin characters. On Linux, the name can have a maximum of 200 characters. On Windows, there is no length restriction. However, a maximum of 40 characters is recommended on all platforms.
3
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.
4
Use the Schedule, Source Options, and Advanced Options lists to configure any additional required options.
5
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.
Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen