Chat now with support
Chat with Support

NetVault Plug-in for DB2 11.4.5 - User Guide

Prerequisites (Windows only)

On Windows, the following requirements must be met before you attempt to relocate the tablespaces:

•
Ensure that the required path exists on the client. If it does not, create the path.
•
Ensure that the DB2_CREATE_DB_ON_PATH parameter is enabled.

Note the following:

•
If the plug-in cannot find the specified path, the restore job fails with the following message in the NetVault Backup Logs:
SQL1052N The database path <path> does not exist.
•
The same message is displayed in the NetVault Backup Logs if you do not enable the DB2_CREATE_DB_ON_PATH parameter. Also, the following message is displayed in the DB2 Instance diagnostic file, db2diag.log:
An attempt is made to create a database on path without first enabling
this feature using DB2_CREATE_DB_ON_PATH registry variable. Please enable
it first, then retry again.

In DB2 9.x and later, the DB2_CREATE_DB_ON_PATH parameter lets you create databases under a path. In pre-DB2 9.x versions, only the root directory was supported. For example:

•
Create Database statement in pre-9.x DB2 versions:
db2 create database mydb on c
•
Create Database statement in 9.x and later versions:
db2 create database mydb on c:\mydb

To set the DB2_CREATE_DB_ON_PATH parameter from the command prompt, perform the following steps.

1
At the prompt, type:
db2set DB2_CREATE_DB_ON_PATH=YES
2
Restart the DB2 instance:
db2stop
db2start

Restore procedure

To rename or relocate data, or both, during a restore, perform the following steps.

1
In the Navigation pane, click Create Restore Job, select Plug‑in for DB2 from the Plugin Type list, select the applicable saveset, and click Next.
For more information, see Selecting data for a restore.
2
To rename a database, do the following:
a
Select the database on the Create Selection Set page.
b
From the Actions list, select Rename.
c
In the Rename/Relocate dialog box, enter the new name in the Rename box, and click Ok.
The plug-in updates the database node to display the new name in parentheses.
 
* 
NOTE: The plug-in does not let you rename individual tablespaces.
3
To relocate the data, do the following:
•
To relocate all tablespaces to the same directory, select the Tablespaces node. From the Actions list, select Rename. In the Rename/Relocate dialog box, enter the new location in the Relocate box, and click Ok.
•
To relocate individual tablespaces, open the Tablespaces node, and select the applicable tablespace. From the Actions list, select Rename. In the Rename/Relocate dialog box, enter the new location in the Relocate box, and click Ok.
 
* 
IMPORTANT: When you relocate the individual tablespaces, also specify a path for the parent Tablespaces node. This directory is used to restore the individual tablespaces and Archived Log files for which you have not specified any relocation path.
The plug-in updates the tablespace node to display the new location in parentheses.
 
* 
NOTE: You cannot relocate tablespaces that are managed by automatic storage. This issue is a functional limitation of DB2.
4
Configure the applicable restore options.
For more information, see Setting restore options.
5
Complete and submit the job.
For more information, see Finalizing and submitting the job.

Restoring a database to an alternate server

During a restore, you can also relocate a database to an alternate DB2 Server, which can be useful while migrating a server or performing a disaster recovery operation.

Before you start the restore procedure, review the following notes and set up the target system:

•
Install the DB2 Server software: Install the DB2 Server software on the target system. The software version must be the same as that running on the original server.
•
Install NetVault Backup and the Plug‑in for DB2: Install the NetVault Backup Server or Client software and the plug-in on the target system. The software version must be the same as the version on the original server.
•
Add the NetVault Backup Client to the NetVault Backup Server: If the target system is a NetVault Backup Client, add it to the NetVault Backup Server. For details, see the Quest NetVault Backup Administrator’s Guide.
•
Add the DB2 Instance to the plug-in: In the Configure dialog box, specify the installation path. For more information, see Configuring default settings.

To restore a database to an alternate server, perform the following steps.

1
Start the NetVault Backup WebUI on the NetVault Backup Server.
2
In the Navigation pane, click Create Restore Job, select Plug‑in for DB2 from the Plugin Type list, select the applicable saveset, and click Next.
3
Open the saveset that contains that database backup, and select the database.
For more information, see Selecting data for a restore.
4
Configure the applicable restore options, and click Next.
For more information, see Setting restore options.
5
In the Target Client list, select the target DB2 Server.
6
Complete and submit the job.
For more information, see Finalizing and submitting the job.

Working with dropped DB2 tables

A standard restore of a DB2 backup using Plug‑in for DB2 does not recover any tables that have been dropped. To restore a dropped table, use the procedures described in this topic.

•
Setting the Dropped Table Recovery option
•
Recovery method 1: soft recovery
•
Recovery method 2: hard recovery
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating