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
  • DATATAGINSC
  • DATATAGNOTINSC
  • DBCONN
  • ESTSQLCOST
  • ROWSREAD
  • ROWSREADINSC
  • ROWSRET
  • RUNTIME
  • RUNTIMEINALLSC
  • SCCONN
  • SORTSHRHEAPUTIL
    Attention: This feature is available in Db2 Version 11.5 Mod Pack 2 and later versions.
  • 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
  • SQ = SQL statement
DOMAINID INTEGER   Identifier for the object with which the threshold is associated. This can be a service class, work action, workload unique ID, or SQL statement. If this is a database threshold, this value is 0.
ENFORCEMENT CHAR (1)   Scope of enforcement for the threshold.
  • D = Database
  • P = Member
  • W = Workload occurrence
QUEUING CHAR (1)  
  • N = The threshold is not queueing
  • Y = The threshold is queueing
MAXVALUE BIGINT   Upper bound specified by the threshold. If THRESHOLDPREDICATE is 'DATATAGINSC' or 'DATATAGNOTINSC', this value encodes one or more data tags.
DATATAGLIST VARCHAR (256) Y If THRESHOLDPREDICATE is 'DATATAGINSC' or 'DATATAGNOTINSC', this value represents one or more data tags as a comma separated list. Otherwise, the null value.
QUEUESIZE INTEGER   If QUEUEING is 'Y', the size of the queue. -1 otherwise.
OVERFLOWPERCENT SMALLINT   Reserved for future use.
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 = Coordinator member of the activity
  • D = All members
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.