QUERY_SUPERVISOR view

The QUERY_SUPERVISOR view contains the threshold rules defined for the Query Supervisor.

Authorization: The caller must have *JOBCTL special authority or be authorized to the QIBM_DB_SQLADM function usage ID.

The following table describes the columns in the view. The system name is QRY_SUPER. The schema is QSYS2.

Table 1. QUERY_SUPERVISOR view
Column Name	System Column Name	Data Type	Description
THRESHOLD_NAME	NAME	VARGRAPHIC(30) CCSID 1200	The name of the threshold.
THRESHOLD_TYPE	TYPE	VARCHAR(30)	The type of threshold CPU TIME The total processing unit time used by the query, in seconds. ELAPSED TIME The total clock time, in seconds. TEMPORARY STORAGE The amount of storage, in megabytes (MB), that the query uses. TOTAL IO COUNT The total number of I/O operations.
THRESHOLD_VALUE	VALUE	BIGINT	The value associated with THRESHOLD_TYPE, in the appropriate units.
JOB_NAMES	JOB_NAMES	VARCHAR(1099) Nullable	A list of job names supervised by this threshold. Each name in the list is padded with blanks to fill ten characters, with a single comma separating the name entries. Contains the null value if all job names are supervised.
INCLUDE_USERS	INCL_USERS	VARCHAR(1099) Nullable	A list of user names supervised by this threshold. Each name in the list is padded with blanks to fill ten characters, with a single comma separating the name entries. Contains the null value if all user names are supervised.
EXCLUDE_USERS	EXCL_USERS	VARCHAR(1099) Nullable	A list of user names that are not supervised by this threshold. Each name in the list is padded with blanks to fill ten characters, with a single comma separating the name entries. Contains the null value if no user names are excluded.
SUBSYSTEMS	SUBSYSTEMS	VARCHAR(1099) Nullable	A list of subsystems supervised by this threshold. Each name in the list is padded with blanks to fill ten characters, with a single comma separating the name entries. Contains the null value if all subsystems are supervised.
DETECTION_FREQUENCY	FREQUENCY	INTEGER	The minimum frequency, in seconds, that a notification is sent for this threshold within a specific thread. During the time interval following a threshold detection, the Query Supervisor does not process additional instances for this threshold, in the same thread. Each time a query is run in a thread, a specific threshold can be processed at most once during the execution of that query. The detection-frequency value provides a protection from having a specific threshold recognized and processed more frequently than desired. If the same threshold is encountered within the same thread and the detection-frequency time period has not yet completed, the associated exit programs are not called and there is no external evidence that the Query Supervisor did not perform threshold detection.
LONG_COMMENT	REMARKS	VARGRAPHIC(2000) CCSID 1200 Nullable	Description of this threshold rule. Contains the null value if the rule has no descriptive text.

Example

List all the thresholds defined for the Query Supervisor.

SELECT *
  FROM QSYS2.QUERY_SUPERVISOR ORDER BY THRESHOLD_TYPE, THRESHOLD_VALUE DESC;