Altering a threshold

Alter thresholds using the ALTER THRESHOLD statement. You might alter a threshold to modify the limit imposed on a specific resource.

Before you begin

To alter a threshold, you require SQLADM, WLMADM, or DBADM authority. To specify any clause other than a COLLECT clause, the authorization ID must include WLMADM or DBADM authority.

See Workload management DDL statements for more information about prerequisites.

To alter a threshold for a work action set, use the ALTER WORK ACTION SET statement with the ADD WORK ACTION keywords. For more information, see ALTER WORK ACTION SET statement.

Restrictions

You cannot alter the threshold type with the ALTER THRESHOLD statement. For example: You cannot change a TOTAL MEMBERCONNECTIONS threshold into a TOTALSCMEMBERCONNECTIONS threshold, for example. If you require a different threshold type, drop the existing thresholds and then create a new threshold.

Procedure

To alter a threshold:

  1. Specify one or more of the following properties for the threshold on the ALTER THRESHOLD statement. You can change the following properties:
    • The boundary for the threshold predicate.
    • The actions to be taken, if the threshold boundary is violated.
    • Whether the threshold is enabled or disabled.
  2. Commit your changes.
    When you commit your changes, the threshold is updated in the SYSCAT.THRESHOLDS view.