DB2 Version 10.1 for Linux, UNIX, and Windows

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	ESTIMATEDSQLCOST threshold	CONCURRENTDBCOORDACTIVITIES threshold	CPUTIME 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	No	No	Yes
DML, including SET statements with embedded READ or WRITE SQL	Yes	Yes	Yes¹	Yes
DDL	Yes	No	Yes¹	No
LOAD	Yes	No	Yes¹	No
ALL	Yes	Some	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)
	SQLROWSREAD threshold	SQLROWSRETURNED threshold	SQLTEMPSPACE threshold
READ, including SET statements with embedded READ SQL	Yes	Yes	Yes
WRITE, including SET statements with embedded WRITE SQL	Yes	Yes	Yes
CALL	No	No (see note)	No
DML, including SET statements with embedded READ or WRITE SQL	Yes	Yes	Yes
DDL	No	No	No
LOAD	No	No	No
ALL	Some	Some	Some

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.