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.

The system entities that WLM_GET_SERVICE_CLASS_AGENTS returns are non-agent threads and processes, such as page cleaners and prefetchers.

The functionality of WLM_GET_SERVICE_CLASS_AGENTS is identical to the functionality of MON_GET_AGENT. Although the functionality for these two routines is the same, the authorization is not necessarily the same. See MON_GET_AGENT for syntax, parameters, information returned, usage notes, and examples.

Authorization

One of the following authorities is required to execute the routine:
  • EXECUTE privilege on the routine
  • DATAACCESS authority
  • DBADM authority
  • SQLADM authority
  • WLMADM authority

Default PUBLIC privilege

None