Chat now with support
Chat with Support

NetVault Plug-in for DB2 11.4.5 - User Guide

Selecting data for a backup

You must use sets — Backup Selection Set, Backup Options Set, Schedule Set, Target Set, and Advanced Options Set — to create a backup job.

Backup Selection Sets are essential for Incremental and Delta Backups. Create the Backup Selection Set during a Full Backup, and use it for Full, Incremental, and Delta Backups. The backup job reports an error if you do not use a Selection Set for the Incremental or Delta Backup. For more information, see the Quest NetVault Backup Administrator’s Guide.

 
* 
TIP: To use an existing set, click Create Backup Job, and select the set from the Selections list.
1
In the Navigation pane, click Create Backup Job.
You can also start the wizard from the Guided Configuration link. In the Navigation pane, click Guided Configuration. On the NetVault Configuration Wizard page, click Create backup jobs.
2
In Job Name, specify a name for the job.
Assign a descriptive name that lets you easily identify the job when monitoring its progress or restoring data. 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
Next to the Selections list, click Create New.
4
In the list of plug-ins, open Plug‑in for DB2 to display the added DB2 instances.
5
Open the target database instance.
6
If a default login account has not been configured for the selected instance, enter the following details in the dialog box that is displayed, and then click Ok to close the dialog box:
•
Account Name: Enter the account name for the DB2 Instance Administrator.
•
Password: Enter the password for the configured user account.
 
* 
NOTE: This step is not applicable if you have configured a default login account for the instance. The plug-in uses the details stored in the configuration file to connect automatically to the instance.
7
When the instance opens, select the items that you want to back up:
•
Full Database Backup: Select the database node.
•
Table space Backup: Select one of the following:
•
To back up all tablespaces, open the database node, and select the Tablespaces node.
•
To back up individual tablespaces, open the Tablespaces node, and select one or more tablespaces.
•
Archived Logs: To back up the Archived Logs, select the Archived Logs node. Archived logs are required for a roll-forward recovery, and must be backed up regularly. You can back up the archived logs separately or together with the tablespaces. The plug-in provides the option to delete the archived logs from the disk after backing them up.
8
Click Save, enter a name in the Create New Set dialog box, and click Save.
The 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.

Setting backup options

The next step involves creating the Backup Options Set or selecting an existing one.

 
* 
TIP: To use an existing set, in the Plugin Options list, select the set that you want to use.
1
Next to the Plugin Options list, click Create New.
2
Configure the following options
•
Backup Mode: Select one of the following options: Online or Offline. For details, see Available backup modes.
•
Backup Type: Select one of the following options: Full, Incremental, or Delta. For details, see Available backup types.
•
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 backed up in parallel. Each session is assigned one tablespace at a time until all tablespaces are backed up.
The default value for this parameter is 1. For backup jobs created with plug-in v3.0 or any earlier versions, it is implicitly set to 1.
If you set this parameter to a value larger than the number of tablespaces being backed up, the plug-in starts the requested number of sessions and each session creates a backup stream. However, some of the backup streams contain just a header and a trailer generated by DB2, and no tablespace data. This issue results in inefficient backups and uses more media than necessary.
If some of the selected tablespaces are small while others are large, reduce the number of sessions accordingly. For example, to back up two small and two large databases, you can set this parameter to 2.
 
* 
IMPORTANT: If you are creating an Incremental or Delta Backup job, set this field to 1. If you enter a different number, the plug-in limits the number to 1, and displays the following message upon completion with warnings: Backup Option 'Number of Sessions' = '<configuredNumber>' changed to '1' for 'INCREMENTAL' or 'DELTA' backup
•
Purge Logs: Under Purge Logs, configure the following parameters
•
Purge Archived Logs: To remove the archived logs automatically after they are backed up, select this check box. The plug-in deletes all archived logs except the Active Logs. Also, the plug-in does not delete the number of logs specified in the Logs to Keep Before Active Log option.
•
Logs to Keep before Active Log Option: To specify the number of logs preceding the current active database log in the server that should not be purged, use this option with the Purge Archived Logs option. Enter a number from 1 to 999.
3
Click Save to save the set.
4
In the Create New Set dialog box, specify a name for the set, and click Save.
The 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.

Finalizing and submitting the job

The final steps include setting additional options on the Schedule, Target Storage, 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
Use the Schedule, Target Storage, and Advanced Options lists to configure any additional required options.
2
Click Save or Save & Submit, whichever is applicable.
 
* 
TIP: To run a job that you have already created and saved, select Manage Job Definitions in the Navigation pane, select the applicable job, and click Run Now.
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.

 

Restoring data

•
Restore and recovery overview
•
Restoring from Full Backups
•
Restoring from Incremental Backups
•
Restoring from Delta Backups
•
Advanced restore procedures
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating