REMOVE_QUERY_THRESHOLD procedure
The REMOVE_QUERY_THRESHOLD procedure removes a threshold that is monitored by the Query Supervisor. Removing a threshold only affects subsequently executed queries. Queries that are currently running will continue to use the thresholds that were in effect when the query execution was initiated.
Authorization: The caller must have *JOBCTL special authority or be authorized to the QIBM_DB_SQLADM function usage ID.
The schema is QSYS2.
- threshold-name
- A character or graphic string that specifies the name of an existing threshold to be removed.
Example
Remove the MAXTIME threshold rule.
CALL QSYS2.REMOVE_QUERY_THRESHOLD(THRESHOLD_NAME => 'MAXTIME');