DB2 Version 9.7 for Linux, UNIX, and Windows

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.
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 = Database partition of the coordinator of the activity
  • D = All database partitions
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
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
EXTERNALNAME VARCHAR (128) Y Reserved for future use.
REMARKS VARCHAR (254) Y User-provided comments, or the null value.