MON_GET_SERVICE_SUPERCLASS_STATS table function - Return statistics of service superclasses
The MON_GET_SERVICE_SUPERCLASS_STATS function returns basic statistics of one or more service superclasses.
Authorization
One of the following authorizations
is required:
- EXECUTE privilege on the routine
- DATAACCESS authority
- DBADM authority
- SQLADM authority
- WLMADM authority
Default PUBLIC privilege
None
Syntax
The schema is SYSPROC.
Routine parameters
- service_superclass_name
- An input argument of type VARCHAR(128) that specifies the name of a service superclass in the currently connected database. If the argument is null or an empty string, data is retrieved for all the superclasses in the database.
- member
- An input argument of type INTEGER that specifies a valid member number in the same instance as the currently connected database. Specify -1 for the current database member, or -2 for all active database members. If the null value is specified, -1 is set implicitly.
Information returned
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 |
Usage notes
The MON_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.
Example
The following query displays the
basic statistics for all the service superclasses on the system, across
all database members:
SELECT SUBSTR(SERVICE_SUPERCLASS_NAME, 1, 26) SERVICE_SUPERCLASS_NAME,
MEMBER,
LAST_RESET,
CONCURRENT_CONNECTION_TOP CONCURRENT_CONN_TOP
FROM TABLE(MON_GET_SERVICE_SUPERCLASS_STATS('', -2)) as SCSTATS
Sample output is as follows:
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