Each row represents a threshold.
Column Name | Data Type | Nullable | Description |
---|---|---|---|
THRESHOLDNAME | VARCHAR (128) | Name of the threshold. | |
THRESHOLDID | INTEGER | Identifier for the threshold. | |
ORIGIN | CHAR (1) | Origin of the threshold.
|
|
THRESHOLDCLASS | CHAR (1) | Classification of the threshold.
|
|
THRESHOLDPREDICATE | VARCHAR (15) | Type of the threshold. Possible values are:
|
|
THRESHOLDPREDICATEID | SMALLINT | Identifier for the threshold predicate. | |
DOMAIN | CHAR (2) | Domain of the threshold.
|
|
DOMAINID | INTEGER | Identifier for the object with which the threshold is associated. This can be a service class, work action or workload unique ID. If this is a database threshold, this value is 0. | |
ENFORCEMENT | CHAR (1) | Scope of enforcement for the threshold.
|
|
QUEUING | CHAR (1) |
|
|
MAXVALUE | BIGINT | Upper bound specified by the threshold. | |
QUEUESIZE | INTEGER | If QUEUING is 'Y', the size of the queue. -1 otherwise. | |
COLLECTACTDATA | CHAR (1) | Specifies what activity data should be collected by the applicable
event monitor.
|
|
COLLECTACTPARTITION | CHAR (1) | Specifies where activity data is collected.
|
|
EXECUTION | CHAR (1) | Indicates the execution action taken after a threshold has
been exceeded.
|
|
REMAPSCID | SMALLINT | Target service subclass ID of the REMAP ACTIVITY action. | |
VIOLATIONRECORDLOGGED | CHAR (1) | Indicates whether a record is written to the event monitor
upon threshold violation.
|
|
CHECKINTERVAL | INTEGER | The interval, in seconds, in which the threshold condition
is checked if THRESHOLDPREDICATE is:
|
|
ENABLED | CHAR (1) |
|
|
CREATE_TIME | TIMESTAMP | Time at which the threshold was created. | |
ALTER_TIME | TIMESTAMP | Time at which the threshold was last altered. | |
REMARKS | VARCHAR (254) | Y | User-provided comments, or the null value. |