wlm_admission_ctrl - WLM admission control configuration parameter

This parameter specifies whether Db2® workload manager (WLM) admission control is enabled.

Configuration type
Database
Parameter type
Configurable online
Default [range]
The default depends on the setting of the DB2_WORKLOAD registry variable:
  • If DB2_WORKLOAD=ANALYTICS, the default is YES
  • If DB2_WORKLOAD is set to any other value, the default is NO
The range is [YES, NO]

Usage notes

  • Possible values:
    YES
    WLM admission control is enabled. Running queries are controlled by WLM admission control.
    NO
    WLM admission control is disabled. Running queries are not controlled by WLM admission control. However, queries that are queued for admission control are allowed to run.
In a partitioned database environment, the system-wide setting of the wlm_admission_ctrl configuration parameter is based on the setting for the catalog member:
  • If the setting is changed for a non-catalog member, and if the new setting is not the same as the setting for the catalog member, the next time that the database is started on the non-catalog member, its setting reverts to that for the catalog member.
  • If the setting is changed for the catalog member, that new value is applied to a non-catalog member the next time that the database starts on the non-catalog member. Until then, the setting on the non-catalog member has one of the following values:
    • The value that was in effect when the database started
    • The value that was last explicitly set by the user for that member after the database began running on that member