The WLM_GET_SERVICE_SUPERCLASS_STATS function returns basic statistics for one or more service superclasses.
>>-WLM_GET_SERVICE_SUPERCLASS_STATS--(--service_superclass_name--,--> >--member--)---------------------------------------------------><
The schema is SYSPROC.
None
SELECT SUBSTR(SERVICE_SUPERCLASS_NAME, 1, 26) SERVICE_SUPERCLASS_NAME,
MEMBER,
LAST_RESET,
CONCURRENT_CONNECTION_TOP CONCURRENT_CONN_TOP
FROM TABLE(WLM_GET_SERVICE_SUPERCLASS_STATS('', -2)) as SCSTATS
SERVICE_SUPERCLASS_NAME MEMBER ...
-------------------------- -------------- ...
SYSDEFAULTSYSTEMCLASS 0 ...
SYSDEFAULTMAINTENANCECLASS 0 ...
SYSDEFAULTUSERCLASS 0 ...
... LAST_RESET CONCURRENT_CONN_TOP
... -------------------------- -------------------
... 2006-09-05-09.38.44.396788 0
... 2006-09-05-09.38.44.396795 0
... 2006-09-05-09.38.44.396796 1
The WLM_GET_SERVICE_SUPERCLASS_STATS table function returns one row of data per service superclass and per member. The function does not aggregate data across service superclasses (on a member) or across members (for one or more service superclasses). However, you can use SQL queries to aggregate data, as shown in the previous example.
Column name | Data type | Description |
---|---|---|
SERVICE_SUPERCLASS_NAME | VARCHAR(128) | service_superclass_name - Service superclass name monitor element |
DBPARTITIONNUM | SMALLINT | dbpartitionnum - Database partition number monitor element |
LAST_RESET | TIMESTAMP | last_reset - Last Reset Timestamp monitor element |
CONCURRENT_CONNECTION_TOP | INTEGER | concurrent_connection_top - Concurrent connection top monitor element |
MEMBER | SMALLINT | member - Database member monitor element |