DB2 Database Administrator Load Copy Operations

You can use the Commvault library to perform the DB2 load copy operation.

You can move the data using the DB2 Load Copy utility from the primary server to the standby server. The operation allows you to move a large volume of data into newly created tables or tables that already contain data. It also enables you to write the formatted pages directly into the database rather than using SQL inserts.

Procedure

Use the following steps to perform a load copy operation

1. Connect to the Primary database.

   Example:

   db2 connect to sample

2. Execute the DB2 command to export the data file.

   Example:

   db2 "export to emp1.del of del select * from employee"
   

3. Execute the db2 command to perform a Load copy operation.

   View the db2diag.log to verify whether the load operation is successful on the standby server instance.

   Example:

   db2 "load from /home/db2inst2/emp1.del of del replace into empcopy copy yes load '/opt/commvault/Base/libDb2Sbt.so'"
   

   A restore operation to restore the load copy image of the last incremental backup will automatically commence on the standby DB2 server.