Each row represents a work class defined for a work class set.
Column Name | Data Type | Nullable | Description |
---|---|---|---|
WORKCLASSNAME | VARCHAR (128) | Name of the work class. | |
WORKCLASSSETNAME | VARCHAR (128) | Y | Name of the work class set. |
WORKCLASSID | INTEGER | Identifier for the work class. | |
WORKCLASSSETID | INTEGER | Identifier for the work class set to which this work class belongs. This column refers to the WORKCLASSSETID column in the SYSCAT.WORKCLASSSETS view. | |
CREATE_TIME | TIMESTAMP | Time at which the work class was created. | |
ALTER_TIME | TIMESTAMP | Time at which the work class was last altered. | |
WORKTYPE | SMALLINT | The type of DB2® activity.
|
|
RANGEUNITS | CHAR (1) | The units to use for the bottom and top range.
|
|
FROMVALUE | DOUBLE | Y | The low value of the range in the units specified by the RANGEUNITS. Null value when RANGEUNITS is blank. |
TOVALUE | DOUBLE | Y | The high value of the range in the units specified by the RANGEUNITS. Null value when RANGEUNITS is blank. -1 value is used to indicate no upper bound. |
ROUTINESCHEMA | VARCHAR (128) | Y | Schema name of the procedures that are called from the CALL statement. Null value when WORKTYPE is not 4 (CALL) or 1 (ALL). |
INITIALSQLDATAPRIORITY | CHAR (1) | Reserved for future use. | |
EVALUATIONORDER | SMALLINT | Uniquely identifies the evaluation order used for choosing a work class within a work class set. |