SYSCAT.WORKCLASSATTRIBUTES catalog view

Each row represents an attribute in the definition of a work class.

Table 1. SYSCAT.WORKCLASSATTRIBUTES Catalog View
Column Name Data Type Nullable Description
WORKCLASSNAME VARCHAR (128)   Name of the work class.
WORKCLASSSETNAME VARCHAR (128)   Name of the work class set.
WORKCLASSID INTEGER   Identifier for the work class.
WORKCLASSSETID INTEGER   Identifier for the work class set.
TYPE VARCHAR (30)   The type of work class attribute. Possible values are:
  • WORK TYPE
  • TIMERONCOST
  • CARDINALITY
  • DATA TAG
  • ROUTINE SCHEMA
  • RUNTIME
VALUE1 DOUBLE Y The meaning of this value depends on the value in the TYPE column:
TYPE='WORK TYPE'
A number that indicates the type of database activity:
  • 1 = ALL
  • 2 = READ
  • 3 = WRITE
  • 4 = CALL
  • 5 = DML
  • 6 = DDL
  • 7 = LOAD
TYPE='TIMERONCOST'
The low value in the range.
TYPE='CARDINALITY'
The low value in the range.
TYPE='DATA TAG'
The tag that the estimated data tag list must contain.
TYPE='ROUTINE SCHEMA'
The null value.
VALUE2 DOUBLE Y The meaning of this value depends on the value in the TYPE column:
TYPE='WORK TYPE'
The null value.
TYPE='TIMERONCOST'
The high value in the range. The value -1 indicates that there is no upper bound.
TYPE='CARDINALITY'
The high value in the range. The value -1 indicates that there is no upper bound.
TYPE='DATA TAG'
The null value.
TYPE='ROUTINE SCHEMA'
The null value.
VALUE3 VARCHAR (128) Y The meaning of this value depends on the value in the TYPE column. If TYPE='ROUTINE SCHEMA', it specifies the schema name of the procedures that are called by the CALL statement. Otherwise, it is the null value.