DB2 10.5 for Linux, UNIX, and Windows

CONCURRENTWORKLOADOCCURRENCES threshold

The CONCURRENTWORKLOADOCCURRENCES threshold is an aggregate threshold that specifies the maximum number of workload occurrences that can run concurrently on the coordinator member.

Type: Aggregate
Definition domain: Workload
Enforcement scope: Member
Tracked work: Workload occurrences
Queuing: No
Unit: Number of concurrent workload occurrences
Predictive or reactive: Predictive

When a workload occurrence is started, if the work that it generates is sent to non-coordinator members, the work on these members does not count towards the concurrent threshold total on the coordinator member. For example, assume that a CONCURRENTWORKLOADOCCURRENCES threshold is defined to permit only one occurrence of workload A on a member. Then assume that an application connects to member 1, resulting in an occurrence of workload A being started, and that this workload causes work to be sent to database members 1, 2, and 3. In this situation, the total number of occurrences of workload A is one on member 1 and zero on database members 2 and 3. Therefore, if another application connects to member 1 and another occurrence of workload A is started on member 1, that workload is rejected. However, new occurrences of workload A can still be started on database members 2 and 3.