SYSCAT.WORKACTIONSETS catalog view

Each row represents a work action set.

Table 1. SYSCAT.WORKACTIONSETS Catalog View
Column Name Data Type Nullable Description
ACTIONSETNAME VARCHAR (128)   Name of the work action set.
ACTIONSETID INTEGER   Identifier for the work action set.
WORKCLASSSETNAME VARCHAR (128) Y Name of the work class set.
WORKCLASSSETID INTEGER   The identifier of the work class set that is to be mapped to the object specified by the OBJECTID. This column refers to WORKCLASSSETID in the SYSCAT.WORKCLASSSETS view.
CREATE_TIME TIMESTAMP   Time at which the work action set was created.
ALTER_TIME TIMESTAMP   Time at which the work action set was last altered.
ENABLED CHAR (1)  
  • N = This work action set is disabled.
  • Y = This work action set is enabled.
OBJECTTYPE CHAR (1)  
  • b = Service superclass
  • w = Workload
  • Blank = Database
OBJECTNAME VARCHAR (128) Y Name of the service class or workload.
OBJECTID INTEGER   The identifier of the object to which the work class set (specified by the WORKCLASSSETID) is mapped. If the OBJECTTYPE is 'b', the OBJECTID is the ID of the service superclass. If the OBJECTTYPE is 'w', the OBJECTID is the ID of the workload. If the OBJECTTYPE is blank, the OBJECTID is -1.
REMARKS VARCHAR (254) Y User-provided comments, or the null value.