Use the DB2 High Performance Unload tools to perform bulk table unloads from an offline backup image that uses the Commvault vendor library.
You can run the tools by using one of the following methods:
-
The command line interface
-
The control file, by specifying the unload options and then using the -f command line option
Note: IBM only supports offline backup images.
For more information, go to the IBM Knowledge Center, DB2 High Performance Unload tools.
Example
Recover the table data from an offline backup image by using the control file.
In this example the database name is SAMPLE, the table name is EMP and the control file name is SampleEmpData.ctl.
The control file has the following lines.
GLOBAL CONNECT TO SAMPLE;
UNLOAD TABLESPACE
DB2 NO
QUIESCE NO
LOCK NO
USING BACKUP DATABASE SAMPLE LOAD "/opt/commvault/Base64/libDb2Sbt.so" taken at 20170629175725;
SELECT * FROM EMP;
OUTFILE("/tmp/EMP.out")
FORMAT DEL;
On the command line, run the following command:
db2hpu -f /db2/SampleEmpData.ctl