Each row represents a workload.
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) |
|
|
ALLOWACCESS | CHAR (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.
|
|
COLLECTACTDATA | CHAR (1) | Specifies what activity data should be collected by the applicable
event monitor.
|
|
COLLECTACTPARTITION | CHAR (1) | Specifies where activity data is collected.
|
|
COLLECTDEADLOCK | CHAR (1) | Specifies that deadlock events should be collect by the applicable
event monitor.
|
|
COLLECTLOCKTIMEOUT | CHAR (1) | Specifies that lock timeout events should be collect by the
applicable event monitor.
|
|
COLLECTLOCKWAIT | CHAR (1) | Specifies that lock wait events should be collect by the applicable
event monitor.
|
|
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.
|
|
COLLECTUOWDATA | CHAR (1) | Specifies what unit of work data should be collected by the
applicable event monitor.
|
|
EXTERNALNAME | VARCHAR (128) | Y | Reserved for future use. |
REMARKS | VARCHAR (254) | Y | User-provided comments, or the null value. |