Thresholds that can be used in work actions
Work action sets that you define for databases can contain work actions that specify thresholds.
The following thresholds are supported:
- Aggregate threshold:
- Activity thresholds:
- ACTIVITYTOTALTIME
- ACTIVITYTOTALRUNTIME
- CPUTIME
- ESTIMATEDSQLCOST
- SORTSHRHEAPUTILAttention: This feature is available in Db2 Version 11.5 Mod Pack 2 and later versions.
- SQLROWSREAD
- SQLROWSRETURNED
- SQLTEMPSPACE