DB2 10.5 for Linux, UNIX, and Windows

Workload management routines

This grouping of routines and views can be used to achieve effective management of work and workloads in your 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_ALTER_MEMBER_SUBSET procedure - Alter a member subset object
The WLM_ALTER_MEMBER_SUBSET procedure alters an existing member subset database object.
WLM_CREATE_MEMBER_SUBSET procedure - Create a member subset object
The WLM_CREATE_MEMBER_SUBSET procedure creates a member subset database object.
WLM_DROP_MEMBER_SUBSET procedure - Drop a member subset object
The WLM_DROP_MEMBER_SUBSET procedure drops an existing member subset database object.
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 DB2 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).