Workload management routines

This grouping of routines and views can be used to achieve effective management of work and workloads in your database.

WLM_ENABLE_ADMISSION_CTRL procedure - Enabling the adaptive workload manager
The WLM_ENABLE_ADMISSION_CTRL procedure is used to enable or disable the adaptive workload manager on a connected database.
WLM_CANCEL_ACTIVITY procedure - Cancel an activity
This procedure cancels a given activity. If the cancel takes place, an error message will be returned to the application that submitted the activity that was cancelled.
WLM_CAPTURE_ACTIVITY_IN_PROGRESS procedure - Collect activity information for activities event monitor
The WLM_CAPTURE_ACTIVITY_IN_PROGRESS procedure gathers information about a specified activity and writes the information to the active activities event monitor.
WLM_COLLECT_STATS procedure - Collect and reset workload management statistics
The WLM_COLLECT_STATS procedure gathers statistics for service classes, workloads, work classes, and threshold queues and writes them to the statistics event monitor.
WLM_GET_CONN_ENV - get settings for activity data collection for a connection
The WLM_GET_CONN_ENV table function returns for a particular connection the values of settings that control collection of activity data and section actuals.
WLM_GET_QUEUE_STATS table function - Return threshold queue statistics
The WLM_GET_QUEUE_STATS function returns basic statistics for one or more threshold queues on all active members. This function returns one row of statistics for each threshold queue.
WLM_GET_SERVICE_CLASS_AGENTS table function - list agents running in a service class
The WLM_GET_SERVICE_CLASS_AGENTS function returns the list of agents, fenced mode processes (db2fmp processes), and system entities on a specified member that are running in a specified service class or on behalf of a specified application.
WLM_GET_SERVICE_CLASS_WORKLOAD_OCCURRENCES table function - list workload occurrences
The WLM_GET_SERVICE_CLASS_WORKLOAD_OCCURRENCES function returns the list of all workload occurrences running in a specified service class on a particular member. A workload occurrence is a specific database connection whose attributes match the definition of a workload and hence is associated with or assigned to the workload.
WLM_GET_SERVICE_SUBCLASS_STATS table function - Return statistics of service subclasses
The WLM_GET_SERVICE_SUBCLASS_STATS function returns basic statistics for one or more service subclasses.
WLM_GET_SERVICE_SUPERCLASS_STATS table function - Return statistics of service superclasses
The WLM_GET_SERVICE_SUPERCLASS_STATS function returns basic statistics for one or more service superclasses.
WLM_GET_WORK_ACTION_SET_STATS table function - Return work action set statistics
The WLM_GET_WORK_ACTION_SET_STATS function returns the statistics for a work action set.
WLM_GET_WORKLOAD_OCCURRENCE_ACTIVITIES table function - Return a list of activities
The WLM_GET_WORKLOAD_OCCURRENCE_ACTIVITIES function returns the list of all activities that were submitted by the specified application on the specified member and have not yet been completed.
WLM_GET_WORKLOAD_STATS table function - Return workload statistics
The WLM_GET_WORKLOAD_STATS function returns one row of workload statistics for every combination of workload name and database member number.
WLM_SET_CLIENT_INFO procedure - Set client information
The WLM_SET_CLIENT_INFO procedure sets client information associated with the current connection at the database server.
WLM_SET_CONN_ENV - enable collection of activity data and measurement of section actuals
The WLM_SET_CONN_ENV procedure enables for a particular connection the collection of activity data and measurement of section actuals (runtime statistics measured during section execution).
WLM_SET_SESSION_PRIORITY procedure - Set the priority of a given session
The WLM_SET_SESSION_PRIORITY stored procedure is used to permanently set the priority of a given session to the indicated session priority level.