DB2 Version 9.7 for Linux, UNIX, and Windows

SYSCAT.THRESHOLDS catalog view

Each row represents a threshold.

Table 1. SYSCAT.THRESHOLDS Catalog View
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.
  • U = Threshold was created by a user
  • W = Threshold was created through a work action set
THRESHOLDCLASS CHAR (1)   Classification of the threshold.
  • A = Aggregate threshold
  • C = Activity threshold
THRESHOLDPREDICATE VARCHAR (15)   Type of the threshold. Possible values are:
  • AGGTEMPSPACE
  • CONCDBC
  • CONCWCN
  • CONCWOC
  • CONNIDLETIME
  • CPUTIME
  • CPUTIMEINSC
  • DBCONN
  • ESTSQLCOST
  • ROWSREAD
  • ROWSREADINSC
  • ROWSRET
  • SCCONN
  • TEMPSPACE
  • TOTALTIME
  • UOWTOTALTIME
THRESHOLDPREDICATEID SMALLINT   Identifier for the threshold predicate.
DOMAIN CHAR (2)   Domain of the threshold.
  • DB = Database
  • SB = Service subclass
  • SP = Service superclass
  • WA = Work action set
  • WD = Workload definition
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.
  • D = Database
  • P = Database partition
  • W = Workload occurrence
QUEUING CHAR (1)  
  • N = The threshold is not queuing
  • Y = The threshold is queuing
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.
  • D = Activity data with details
  • N = None
  • S = Activity data with details and section environment
  • V = Activity data with details and values
  • 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
EXECUTION CHAR (1)   Indicates the execution action taken after a threshold has been exceeded.
  • C = Execution continues
  • F = Application is forced off the system
  • R = Execution is remapped to a different service subclass
  • S = Execution stops
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.
  • N = No
  • Y = Yes
CHECKINTERVAL INTEGER   The interval, in seconds, in which the threshold condition is checked if THRESHOLDPREDICATE is:
  • 'CPUTIME'
  • 'CPUTIMEINSC'
  • 'ROWSREAD'
  • 'ROWSREADINSC'
Otherwise, -1.
ENABLED CHAR (1)  
  • N = This threshold is disabled.
  • Y = This threshold is enabled.
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.