Use this procedure to restore the DB2 tables with the "Do Not Import" option.
You can use the table export dump files when you want to customize your command line.
Procedure
-
Perform a table level backup.
-
The restore uses a staging path on the target and places all input and output files in the dump file path. These paths must have read and write access for the DB2 user.
Before You Begin
-
From the CommCell Browser, expand Client Computers > client > DB2 >instance.
-
Right-click the backup_set, point to All Tasks, and then click Browse and Restore.
-
Select the Table View check box and click View Content.
-
Optional: You can include or exclude any of the following tables in the restore, dependent, referenced and recursively dependent tables.
You can view the table architecture in the left pane. The architecture has the following format:
\+table view+\<db2_instance_name>\<db2_db_name>\<db2_db_schema_name>\<db2_table_names>
Right-click the table, and choose whether to include or exclude dependent or referenced tables.
Option
Description
Deselect All Dependent Tables
Exclude all dependent tables
Select All Dependent Tables
Include all dependent tables
Deselect All Dependent Tables
Exclude all recursive referenced tables
Select All Dependent Tables
Include all recursive referenced tables
Deselect All Referenced Tables
Exclude all referenced tables
Select All Referenced Tables
Include all referenced tables
-
From the Browse window, select the tables to restore and click Recover All Selected.
The Table Restore Options dialog box appears.
-
On the General tab, the selected tables are listed in the Users/Tables selected for restore box.
-
Optional: On the General tab, choose whether to use an auxiliary database:
The Commvault software uses the auxiliary database to export the tables. You can restore the tables to an auxiliary database regardless of whether the database exists.
Option
Steps
Use an auxiliary database
-
Select the Auxiliary Database check box.
-
Select the auxiliary database host from the Destination Computer list.
-
Select the auxiliary database instance from the Destination Instance list.
-
Enter the auxiliary database name in the Target Database Name box.
-
Enter the full path for the target database in the Target Database Path box.
-
Enter the full path to the directory for the table dump files in the Export Destination for Table Dump Files box.
The dump file directory contains the export, import and table creation information. The information is stored for reuse.
Warning: If the auxiliary database exists, the database is overwritten to the Target Database Path.
Do not use an auxiliary database
If you choose the option to not use an auxiliary database, the Commvault software automatically creates a temporary auxiliary database with the name j<job_id> on the same DB2 instance as the source database and then uses it for the restore.
-
Enter the full path for the target database in the Target Database Path box.
Note: The directory must be empty.
-
Enter the full path to the directory for the table dump files in the Export Destination for Table Dump Files box.
-
-
On the Table Restore Options tab, select the Do Not Import option.
The table export dump files will be generated on the dump file path (General tab, Export Destination for Table Dump Files box).
-
On the Restore Options tab, select the restore time option.
By default the database tables are restored to the current time.
-
To restore the database tables to the end of the logs (the current time), select the To the End of the logs option.
-
To restore the database tables to a point-in-time, select the To a Point in Time option and enter the date and time.
-
To restore the database tables to the earliest time during a rollforward operation that the database was consistent, select the To End of Backup option.
For additional information on this option, go to the IBM website, END OF BACKUP.
-
-
Click OK to close the Table Restore Options dialog box.