IBM DB2 Database Backups

  • Updated on Apr 12, 2025
  • Published on Feb 16, 2021

Overview:

The IBM DB2 module is installed via the Commvault console after the Commvault File System Agent is installed and configured. If the servers are configured in a cluster, please note the details about the configuration in the SMC ticket that corresponds with this work effort.

Version & Requirements:

http://documentation.commvault.com/commvault/v11/article?p=2893_2.htm

System Requirements - IBM DB2 iDataAgent

Security & Permissions:

Expedient requires a DB2 user with SYSADM, SYSCTRL, or SYSMAINT and DBADM privileges to run backup and restore operations.

Disk Space:

  • 2 GB minimum disk space is required for software installation.

  • 256 MB is required for the job result directory.

  • 256 MB is required for the log directory.

Data Set:

Backups include the following data:

NOTE: The Commvault File System Agent will be leveraged to back up the DB2 application files that are associated with the DB2 installation.

  • DB2 database objects

  • DB2 history files

  • DB2 archive log files

Special Considerations:

The following paths must be manually created on the server prior to the Commvault DB2 module installation:

NOTE: If the DB2 Instance is clustered, these directories must be created on a shared disk; otherwise, they can be created on any disk with sufficient free space.

\Commvault_Backups\Audit_Error
\Commvault_Backups\Logs
\Commvault_Backups\Retrieve

The following DB2 parameters must updated for Expedient to configure and protect the DB2 database(s) with Commvault:

  • LOGARCHMETH1

    Use this parameter to specify the Commvault library that will be used to archive and manage the DB2 database log files.

  • LOGARCHOPT1

    Use this parameter to enable the DB2 to communicate with Commvault storage system during the Log archive and retrieve operations.

  • VENDOROPT – vendor

    Use this parameter to enable the DB2 to communicate with Commvault storage system during backup, restore, or load copy operations.

  • TRACKMOD

    Enable this parameter to allow the incremental/delta backups.

In order for Commvault to load its Media Library for Data Protection, the DB2 instance must be restarted post Commvault DB2 module installation.