Work classifications supported by thresholds

Although any of the threshold types that can be used in work actions can be associated with any work class, not all types of database activities are supported for all of those threshold types.

For example, if you create a work class for DDL, then associate that work class with an ESTIMATEDSQLCOST threshold work action, that threshold will not apply to any of the requests that are classified under DDL because DDL statements do not have an estimated cost. If you create a work class for ALL, then associate that work class with an ESTIMATEDSQLCOST threshold work action, although all database activities belong to the ALL work class, the threshold will only apply to the database activities that have an estimated cost.

The following tables show which work class categories are supported by which threshold types:

Table 1. Work classification supported by thresholds
	ACTIVITYTOTALTIME threshold	ACTIVITYTOTALRUNTIME threshold	ACTIVITYTOTALRUNTIMEINALLSC threshold	ESTIMATEDSQLCOST threshold
READ, including SET statements with embedded READ SQL	Yes	Yes	Yes	Yes
WRITE, including SET statements with embedded WRITE SQL	Yes	Yes	Yes	Yes
CALL	Yes	Yes	Yes	No
DML, including SET statements with embedded READ or WRITE SQL	Yes	Yes	Yes	Yes
DDL	Yes	Yes	Yes	No
LOAD	Yes	Yes	Yes	No
ALL	Yes	Yes	Yes	Some

Note:

Activities that run within user-defined functions (UDFs) and that contain these work classifications are not affected by the CONCURRENTDBCOORDACTIVITIES threshold.

Table 2. Work classification supported by thresholds (continued)
	CONCURRENTDBCOORDACTIVITIES threshold	CPUTIME threshold	SORTSHRHEAPUTIL threshold	SQLROWSREAD threshold	SQLROWSRETURNED threshold	SQLTEMPSPACE threshold
READ, including SET statements with embedded READ SQL	Yes¹	Yes	Yes	Yes	Yes	Yes
WRITE, including SET statements with embedded WRITE SQL	Yes¹	Yes	Yes	Yes	Yes	Yes
CALL	No	Yes	No	No	No (see note)	No
DML, including SET statements with embedded READ or WRITE SQL	Yes¹	Yes	Yes	Yes	Yes	Yes
DDL	Yes¹	No	No	No	No	No
LOAD	Yes¹	No	No	No	No	No
ALL	Yes¹	Some	Some	Some	Some	Some

Attention: SORTSHRHEAPUTIL threshold is available in Db2 Version 11.5 Mod Pack 2 and later versions.

Note:

Although the statements in the procedure called may return rows, because the rows are not returned as a result of the CALL statement they are not controlled by the SQLROWSRETURNED threshold.