DB2 Version 9.7 for Linux, UNIX, and Windows

SYSCAT.WORKCLASSES catalog view

Each row represents a work class defined for a work class set.

Table 1. SYSCAT.WORKCLASSES Catalog View
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.
  • 1 = ALL
  • 2 = READ
  • 3 = WRITE
  • 4 = CALL
  • 5 = DML
  • 6 = DDL
  • 7 = LOAD
RANGEUNITS CHAR (1)   The units to use for the bottom and top range.
  • C = Cardinality
  • T = Timerons
  • Blank = Not applicable
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.