Creating a Subclient for a DB2 Offline Subclient

When you perform a backup for an offline subclient, the database is deactivated.

Configure the DB2 subclient to perform a full backup of the DB2 database when it is offline. Full backups include all data files and tablespaces for the database.

Before You Begin

Create a backup set for the DB2 database.

Procedure

1. From the CommCell Browser, navigate to Client Computers > client > DB2> instance.

2. Right-click the backupset, point to All Tasks and then click New Subclient.

   The Create New Subclient dialog box appears.

3. On the General tab, in the Subclient name box, enter a name for the subclient.

4. On the Content tab:

   • Select the Data check box.

   • Select the Offline Database option.

5. On the Storage Device tab from the Data Storage Policy list, select the storage policy that the software uses for data backups.

6. Optional: Select the subclient options.

   Include the logs in the backup

   On the Advanced Options tab, select the Back up Log Files check box.

   For more information, see Subclient Properties (Advanced Options).

   Run scripts before or after the backup

   You can choose to run the post-process script even if the backup job failed.

   To pass the database instance name to the script, see Passing the Instance Name to Pre and Post Scripts for Databases.

   On the Pre/Post Process tab:

   1. In the PreBackup Process box, type the full path name for the script.

   2. In the PostBackup Process box, type the full path name for the script.

   3. To run the post backup process regardless of the job's outcome, select the Run Post Process for all attempts check box.

   Use compression to optimize backup storage

   On the Advanced Options tab, select the Use Db2 compression check box.

   When you select this option, the Commvault software applies the DB2 compression feature to all the backups for this subclient.

   For more information about DB2 compression, go to the DB2 website, compression and storage.

   Use DB2 DEDUP DEVICE

   When this is enabled, the DB2 deduplication parameter DEDUP_DEVICE is used. This feature is available starting on DB2 version 9.7 with FixPack 3.

   For additional information about the DB2 DEDUP_DEVICE parameter, go to the DB2 Knowledge Center, DEDUP_DEVICE.

   On the Advanced Options tab, select the Use Dedupe Device check box.

7. Click OK to close the Create New Subclient dialog box.