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.
Refer to Table 1 for a complete list of information that can be returned.
>>-WLM_GET_WORKLOAD_OCCURRENCE_ACTIVITIES--(--application_handle--,--> >--member--)---------------------------------------------------><
The schema is SYSPROC.
None
SELECT SUBSTR(CHAR(COORD_MEMBER),1,5) AS COORD,
SUBSTR(CHAR(MEMBER),1,4) AS MEMB,
SUBSTR(CHAR(UOW_ID),1,5) AS UOWID,
SUBSTR(CHAR(ACTIVITY_ID),1,5) AS ACTID,
SUBSTR(CHAR(PARENT_UOW_ID),1,8) AS PARUOWID,
SUBSTR(CHAR(PARENT_ACTIVITY_ID),1,8) AS PARACTID,
ACTIVITY_TYPE AS ACTTYPE,
SUBSTR(CHAR(NESTING_LEVEL),1,7) AS NESTING
FROM TABLE(WLM_GET_WORKLOAD_OCCURRENCE_ACTIVITIES(1, -2)) AS WLOACTS
ORDER BY MEMB, UOWID, ACTID
COORD MEMB UOWID ACTID PARUOWID PARACTID ACTTYPE NESTING
----- ---- ----- ----- -------- -------- -------- -------
0 0 2 3 - - CALL 0
0 0 2 5 2 3 READ_DML 1
SELECT t.application_handle,
t.uow_id,
t.activity_id,
varchar(p.stmt_text, 256) as stmt_text
FROM table(wlm_get_workload_occurrence_ACTIVITIES(NULL, -1)) as t,
table(mon_get_pkg_cache_stmt(NULL, NULL, NULL, -1)) as p
WHERE t.executable_id = p.executable_id
APPLICATION_HANDLE UOW_ID ACTIVITY_ID STMT_TEXT
------------------ ----------- -------------- ------------------------------
1 1 1 SELECT * FROM SYSCAT.TABLES
47 1 36 INSERT INTO T1 VALUES(123)
Column name | Data type | Description |
---|---|---|
APPLICATION_HANDLE | BIGINT | application_handle - Application handle monitor element |
DBPARTITIONNUM | SMALLINT | dbpartitionnum - Database partition number monitor element |
COORD_PARTITION_NUM | SMALLINT | coord_partition_num - Coordinator partition number monitor element |
LOCAL_START_TIME | TIMESTAMP | local_start_time - Local start time monitor element |
UOW_ID | INTEGER | uow_id - Unit of work ID monitor element |
ACTIVITY_ID | INTEGER | activity_id - Activity ID monitor element |
PARENT_UOW_ID | INTEGER | parent_uow_id - Parent unit of work ID monitor element |
PARENT_ACTIVITY_ID | INTEGER | parent_activity_id - Parent activity ID monitor element |
ACTIVITY_STATE | VARCHAR(32) | activity_state - Activity state monitor element |
ACTIVITY_STATE (continued) | VARCHAR(32) | Activity state. Possible values are as follows:
|
ACTIVITY_TYPE | VARCHAR(32) | Activity type. Possible values are as follows:
Refer to Identify types of work with work classes for a description of the different types of SQL statements that are associated with each activity type. |
NESTING_LEVEL | INTEGER | nesting_level - Nesting level monitor element |
INVOCATION_ID | INTEGER | invocation_id - Invocation ID monitor element |
ROUTINE_ID | INTEGER | routine_id - Routine ID monitor element |
UTILITY_ID | INTEGER | utility_id - Utility ID monitor element |
SERVICE_CLASS_ID | INTEGER | service_class_id - Service class ID monitor element |
DATABASE_WORK_ACTION_SET_ID | INTEGER | One of the following values:
|
DATABASE_WORK_CLASS_ID | INTEGER | One of the following values:
|
SERVICE_CLASS_WORK_ACTION_SET_ID | INTEGER | One of the following values:
|
SERVICE_CLASS_WORK_CLASS_ID | INTEGER | One of the following values:
|
EXECUTABLE_ID | VARCHAR(32) FOR BIT DATA | executable_id - Executable ID monitor element |
TOTAL_CPU_TIME | BIGINT | |
ROWS_READ | BIGINT | |
ROWS_RETURNED | BIGINT | |
QUERY_COST_ESTIMATE | BIGINT | |
DIRECT_READS | BIGINT | |
DIRECT_WRITES | BIGINT | |
ENTRY_TIME | TIMESTAMP | entry_time - Entry time |
MEMBER | SMALLINT | member - Database member monitor element |
COORD_MEMBER | SMALLINT | coord_member - Coordinator member monitor element |
PACKAGE_SCHEMA | VARCHAR(128) | package_schema - Package schema . |
PACKAGE_NAME | VARCHAR(128) | package_name - Package name . |
PACKAGE_VERSION_ID | VARCHAR(64) | package_version_id - Package version. |
SECTION_NUMBER | BIGINT | section_number - Section number. |
STMTNO | INTEGER | stmtno - Statement number monitor element |