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;