Throttling Backup Jobs

Modify backup job performance by modifying job throttling.

You can enable job throttling on a client, and then limit the number of data and log backup jobs that run simultaneously on the client. When the maximum number of concurrent running jobs is reached, new backup jobs submitted for the client are queued and run when current-running jobs complete.

When throttling is on, the maximum number of data and log backup jobs that can simultaneously run is set to 1 by default.

An SnapProtect backup and command line backup are counted as a data jobs. The SnapProtect backup copy to tape job is not counted.

This task applies to the following agents running command line, traditional, or SnapProtect backups:

  • Windows File System
  • UNIX File System
  • DB2
  • DB2 MultiNode
  • IBM i File System Agent
  • Oracle
  • Oracle RAC

    Note: For Oracle RAC, use the Oracle RAC pseudo client name for the client.

    When job throttling is configured for an Oracle RAC pseudo client, the job throttling value is shared by all instances configured for the pseudo client.

    Example

    The Oracle RAC pseudo client Rac_MultiInstance has the data threshold set to 2 and the log threshold set to 3. There are 3 instances configured for the pseudo client, databaseX, databaseY and databaseZ. If databaseY and databaseZ are running backup jobs, a backup job that is started for databaseX is queued and waits for one of the jobs to reach the log backup phase.

  • SAP Oracle
  • NAS

Before You Begin

  • View the current job throttling configuration. On the command line type the following command:

qoperation execscript -sn SetLimitRunningJobs -si 'client' -si 'View'

Procedure

  1. Use the qlogin command to log onto the CommServe.
  2. Enable job throttling. On the command line, type the following command:

    qoperation execscript –sn SetKeyIntoGlobalParamTbl.sql –si ThrottleJobsFeature –si y –si 1

  3. Set the number of simultaneous backup jobs (both data and log) for the client. On the command line, type the following command:

    Run this command on each client that uses job throttling.

    qoperation execscript -sn SetLimitRunningJobs -si 'client'|'Oracle_RAC_pseudo_client_name' -si 'LimitJobs' -si 1

  4. Set the limit for the number of simultaneous data backup jobs. On the command line, type the following command:

    Set the limit to 0 to disable the number of simultaneous backup jobs on the client.

    qoperation execscript -sn SetLimitRunningJobs -si 'client'|'Oracle_RAC_pseudo_client_name' -si 'DataCount' -si limit

  5. This step does not apply to File System agents. Set the limit for the number of simultaneous log backup jobs. On the command line, type the following command:

    qoperation execscript -sn SetLimitRunningJobs -si 'client'|'Oracle_RAC_pseudo_client_name' -si 'LogCount' -si limit

    Note: The log job is not limited when the job contains both data and logs.

  6. Optional: Exclude jobs from being throttled.

    By default, the jobs targeted for immediate execution are not excluded from job throttling. All application command line jobs and CommCell Console jobs run with the immediate option are counted as immediate jobs.

    You can exclude immediate jobs from job throttling. Use this option when you want to run a backup immediately, without waiting for the queue to clear even when the job limits have been reached on the client. When this option is set, scheduled jobs are the only jobs throttled.

    Examples

    Expand All

    Exclude Immediate Jobs from Job Throttling

    qoperation execscript -sn SetLimitRunningJobs -si 'client'|'Oracle_RAC_pseudo_client_name' -si 'Exclude' -si 1

    Include Immediate Jobs in Throttling

    qoperation execscript -sn SetLimitRunningJobs -si 'client'|'Oracle_RAC_pseudo_client_name' -si 'Exclude' -si 0

Disabling Throttling

  1. Use the qlogin command to log onto the CommServe.
  2. Disable throttling on the CommServe. On the command line, type the following command:

    qoperation execscript -sn SetKeyIntoGlobalParamTbl.sql -si ThrottleJobsFeature -si n

    Disable throttling on the client. On the command line, type the following command:

    qoperation execscript -sn SetLimitRunningJobs -si 'client'|'Oracle_RAC_pseudo_client_name' -si 'LimitJobs' -si 0