SYSCAT.WORKLOADS catalog view

Each row represents a workload.

Table 1. SYSCAT.WORKLOADS Catalog View
Column Name Data Type Nullable Description
WORKLOADID INTEGER   Identifier for the workload.
WORKLOADNAME VARCHAR (128)   Name of the workload.
EVALUATIONORDER SMALLINT   Evaluation order used for choosing a workload.
CREATE_TIME TIMESTAMP   Time at which the workload was created.
ALTER_TIME TIMESTAMP   Time at which the workload was last altered.
ENABLED CHAR (1)  
  • N = This workload is disabled.
  • Y = This workload is enabled.
ALLOWACCESS CHAR (1)  
  • N = A UOW associated with this workload will be rejected.
  • Y = A unit of work (UOW) associated with this workload can access the database.
MAXDEGREE SMALLINT   Maximum degree of parallelism for the workload. The valid values are: 1 to 32767, and -1. If MAXIMUM DEGREE is DEFAULT, the value is -1.
SERVICECLASSNAME VARCHAR (128)   Name of the service subclass to which a unit of work (associated with this workload) is assigned.
PARENTSERVICECLASSNAME VARCHAR (128) Y Name of the service superclass to which a unit of work (associated with this workload) is assigned.
COLLECTAGGACTDATA CHAR (1) Specifies what aggregate activity data should be captured for the workload by the applicable event monitor.
  • B = Collect base aggregate activity data
  • E = Collect extended aggregate activity data
  • N = None
COLLECTACTDATA CHAR (1) Specifies what activity data should be collected by the applicable event monitor.
  • D = Activity data with details
  • N = None
  • S = Activity data with details and section environment
  • V = Activity data with details and values. Applies when the COLLECT column is set to 'C'
  • W = Activity data without details
  • X = Activity data with details, section environment, and values
COLLECTACTPARTITION CHAR (1)   Specifies where activity data is collected.
  • C = Coordinator member of the activity
  • D = All members
COLLECTDEADLOCK CHAR (1)   Specifies that deadlock events should be collect by the applicable event monitor.
  • H = Collect deadlock data with past activities only
  • V = Collect deadlock data with past activities and values
  • W = Collect deadlock data without past activities and values
COLLECTLOCKTIMEOUT CHAR (1)   Specifies that lock timeout events should be collect by the applicable event monitor.
  • H = Collect lock timeout data with past activities only
  • N = Do not not collect lock timeout data
  • V = Collect lock timeout data with past activities and values
  • W = Collect lock timeout data without past activities and values
COLLECTLOCKWAIT CHAR (1)   Specifies that lock wait events should be collect by the applicable event monitor.
  • H = Collect lock wait data with past activities only
  • N = Do not not collect lock wait data
  • V = Collect lock wait data with past activities and values
  • W = Collect lock wait data without past activities and values
LOCKWAITVALUE INTEGER   Specifies the time in milliseconds a lock should wait before a lock event is collected by the applicable event monitor; 0 when COLLECTLOCKWAIT = 'N'
COLLECTACTMETRICS CHAR (1)   Specifies the monitoring level for activities submitted by an occurrence of the workload.
  • B = Collect base activity metrics
  • E = Collect extended activity metrics
  • N = None
COLLECTUOWDATAOPTIONS VARCHAR (32)   Specifies what unit of work data is collected by the applicable event monitor. The first position in the string represents whether the collection of unit of work data is enabled.
  • B = Enabled and collect base unit of work data
  • N = Not enabled
Starting from second position, each position in the string represents a specific extended option:
  • 2 = Package Reference List
  • 3 = Executable ID list
Each position representing an extended option is then set to one of the following values:
  • Y = Extended option is included
  • N = Extended option is not included
COLLECTUOWDATA CHAR (1)   Specifies what unit of work data should be collected by the applicable event monitor.
  • B = Collect base unit of work data
  • N = None
  • P = Collect base unit of work data and the package list
This column is deprecated. Information for the column is available from COLLECTUOWDATAOPTIONS.
EXTERNALNAME VARCHAR (128) Y Reserved for future use.
SECTIONACTUALSOPTIONS VARCHAR (32)   Specifies what section actuals are collected during the execution of a section. The first position in the string represents the whether the collection of section actuals is enabled.
  • B = Enabled and collect basic operator cardinality counts and statistics for each object referenced by the section (DML statements only).
  • N = Not enabled.
The second position is always 'N' and reserved for for future use.
COLLECTAGGUOWDATA CHAR (1)   Specifies what aggregate unit of work data should be captured for the workload by the applicable event monitor.
  • B = Collect base aggregate unit of work data
  • N = None
PRIORITY
Attention: This property is available to users of Db2 v11.5.5 and later versions.
 CHAR(8) N Specifies the WLM priority for the workload. The priority can be set to one of the following values:
  • CRITICAL
  • HIGH
  • MEDIUM
  • LOW
REMARKS VARCHAR (254) Y User-provided comments, or the null value.