Creating a Subclient for a DB2 Offline Subclient

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

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. Offline backups do not include the archived log files.

You can perform offline backups when the database is either offline or online.

You can configure the subclient to use the DB2 Advanced Copy Services (ACS) interface. When you use the DB2 ACS interface for an IntelliSnap backup, the Commvault software registers the IntelliSnap backup with the DB2 application catalog.

Best Practice: If you create an offline subclient, then you should also create an archive log subclient so that you can avoid the SQL 1042c error. For more information, see SQL1042c DB2 IntelliSnap Windows Restore Goes Pending.

Before You Begin

Create a backup set for the DB2 database.


  1. From the CommCell Browser, expand Client Computers > client > DB2 > Instance.
  2. Right-click the backup_set, 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, type a name for the subclient.
  4. On the Content tab, select the following options:
    • 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 you want to use.
  6. On the IntelliSnap Operations tab, do the following:
    1. Select the IntelliSnap check box.
    2. From the Available Snap Engines list, select the engine that matches your snapshot type. For a list of available engines for your array, see Snapshot Engine.
    3. To use the DB2 ACS interface, select the Use DB2 ACS Interface check box.
  7. Optional: Select the subclient options.

    Run scripts before or after the backup operation.

    Use compression to optimize backup storage.


    Configure the number of streams that the software uses for the backup operation.

  8. Click OK.

Last modified: 9/26/2018 12:25:43 PM