Modifying the Thresholds for DB2 Log File Backups

When you install the DB2 agent, you specify a DB2 archive log path.

The Commvault software stores DB2 archive logs in this staging path to avoid a log backup job for each log archival request.

When you perform an archival log operation, the Commvault software automatically starts a command line log backup, and then removes the archive logs from the archive log path when either of the following two conditions are met:

  • The size of all the archive logs (in MB) is greater than or equal to the sDb2ThresholdALFS additional setting value. The default value of sDb2ThresholdALFS is 10000 MB.

  • The total number of archive logs is greater than or equal to the sDb2ThresholdALFN additional setting value. The default value of sDb2ThresholdALFN is 50.

If Commcell console for third-party jobs is enabled, you must configure third-party job authentication for DB2. For more information about configuring the client for third-party jobs, see Configuring DB2 and DB2 MultiNode for CommCell Console Third-Party Job Authentication.

Procedure

Additional setting

Category

Type

Value

sDb2ThresholdALFS

Db2Agent

String

The size of the DB2 archive log files, in MB, that triggers the software to start a log backup.

If you want the log files to go directly to media, set the value to 1.

sDb2ThresholdALFN

Db2Agent

String

The number of DB2 archive log files that triggers the software to start a log backup.

If you want the log files to go directly to media, set the value to 1.

Note

If the value of the SDb2ThresholdALFS additional setting or the sDb2ThresholdALFN additional setting is set to 1, you must clear the Backup Log Files check box at the subclient level. If you leave the Backup Log Files check box selected, the backup job will be marked with a CWE status.

What to Do Next

Perform an archival log operation to verify that the setting has taken effect.

How the Commvault Software Works with the DB2 Archive Log Path

Loading...