DB2 10.5 for Linux, UNIX, and Windows

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.

The functionality of WLM_GET_WORKLOAD_OCCURRENCE_ACTIVITIES is identical to the functionality of MON_GET_ACTIVITY. Although the functionality for these two routines is the same, the authorization is not necessarily the same. See MON_GET_ACTIVITY 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

Related reference:
MON_GET_ACTIVITY table function - Return a list of activities