DB2 Version 10.1 for Linux, UNIX, and Windows

UOWTOTALTIME threshold

The UOWTOTALTIME threshold specifies the maximum amount of time that a unit of work may spend in the DB2® engine.

Type: Unit of work
Definition domain: Database, workload, service superclass
Enforcement scope: Database
Tracked work: See the information later in this topic.
Queuing: No
Unit: Time duration expressed in seconds, minutes, hours, or days. If the time unit specified is seconds, this value must be a multiple of 10.
Predictive or reactive: Reactive

The STOP EXECUTION action for a UOWTOTALTIME threshold rolls back the unit of work. The FORCE APPLICATION action forces the application to which the unit of work belongs. The COLLECT ACTIVITY DATA option can be specified for this threshold, but it is ignored.

A UOWTOTALTIME threshold defined on the workload domain overrides any UOWTOTALTIME threshold defined on the service superclass domain. A UOWTOTALTIME threshold defined on the service superclass domain overrides any UOWTOTALTIME threshold defined on the database domain.

Example

The following example creates a threshold FORCE10MINUTEUOW that issues a FORCE APPLICATION command when a unit of work has been executing for more than 10 minutes.

CREATE THRESHOLD FORCE10MINUTEUOW FOR DATABASE ACTIVITIES
   ENFORCEMENT DATABASE
   WHEN UOWTOTALTIME > 10 MINUTES
   FORCE APPLICATION;