ENV_GET_DB2_EDU_SYSTEM_RESOURCES table function - Return information about the database engine dispatchable units
The ENV_GET_DB2_EDU_SYSTEM_RESOURCES table function returns system resource metrics at the instance level for all database engine dispatchable units (EDUs).
Authorization
One of the following authorizations
is required:
- EXECUTE privilege on the routine
- DATAACCESS authority
- SQLADM authority
- DBADM authority
Default PUBLIC privilege
None
Syntax
The schema is SYSPROC.
Routine parameters
- member
- An input parameter of type INTEGER that specifies a valid database member from which the records are to be fetched. Specify -1 or NULL for the current member, or -2 for information from all active database members. An active database member is a database that is available for connection and use by applications. The default value is NULL.
Information returned
Column name | Data type | Description |
---|---|---|
MEMBER | SMALLINT | member - Database member monitor element |
EDU_ID | BIGINT | edu_ID - Engine dispatchable unit ID monitor element |
EDU_NAME | VARCHAR (128) | edu_name - Engine dispatchable unit name monitor element |
DB2_PROCESS_ID | BIGINT | db2_process_id - database process ID monitor element |
TID | BIGINT | agent_tid - Agent thread ID monitor element |
KTID | BIGINT | ktid - Kernel thread ID monitor element |
CPU_USER_TIME_MS | BIGINT | CPU user processing time in microseconds. |
CPU_SYSTEM_TIME_MS | BIGINT | CPU system processing time in microseconds. |
RESOURCE_METHOD | VARCHAR (8) | Resource policy method in use for this EDU. |
RESOURCE_BINDING | VARCHAR (30) | Resource policy binding that is in use for this EDU. |
RESOURCE_GROUP | VARCHAR (30) | Resource group that is associated with the resource policy binding that is in use for this EDU. |
Examples
- List the EDU_NAME and DB2_PROCESS_ID on all members.
This query returns the following output:SELECT EDU_NAME, DB2_PROCESS_ID FROM TABLE (ENV_GET_DB2_EDU_SYSTEM_RESOURCES(-2))
EDU_NAME DB2_PROCESS_ID ----------------------------------- -------------------- db2agntdp (TEST) 4615 db2agntdp (TEST) 4615 db2agent (TEST) 4615 db2evmli (DB2DETAILDEADLOCK) 4615 db2pcsd (TEST) 4615 db2fw3 (TEST) 4615 db2fw2 (TEST) 4615 db2fw1 (TEST) 4615 db2fw0 (TEST) 4615 db2lused (TEST) 4615 db2wlmd (TEST) 4615 db2taskd (TEST) 4615 db2pfchr (TEST) 4615 db2pfchr (TEST) 4615 db2pfchr (TEST) 4615 db2pclnr (TEST) 4615 db2pclnr (TEST) 4615 db2pclnr (TEST) 4615 db2pclnr (TEST) 4615 db2lfr.0 (TEST) 4615 db2loggw (TEST) 4615 db2loggr (TEST) 4615 db2dlock (TEST) 4615 db2agent (TEST) 4615 db2stmm (TEST) 4615 db2resync 4615 db2ipccm 4615 db2wlmtm 4615 db2wlmt 4615 db2licc 4615 db2thcln 4615 db2alarm 4615 db2sysc 4615 33 record(s) selected.
- List TID, RESOURCE_METHOD, and CPU_USER_TIME_MS on all members.
This query returns the following output:SELECT TID, RESOURCE_METHOD, CPU_USER_TIME_MS FROM TABLE (ENV_GET_DB2_EDU_SYSTEM_RESOURCES(-2))
TID RESOURCE_METHOD CPU_USER_TIME_MS -------------------- --------------- ---------------- 46913046964544 - 6970000 46913063741760 - 14950000 46913025993024 - 1260000 46913042770240 - 0 46913030187328 - 0 46913114073408 - 0 46913059547456 - 0 46913038575936 - 0 46913055353152 - 0 46913067936064 - 60000 46913072130368 - 0 46913051158848 - 0 46913080518976 - 0 46913076324672 - 20000 46913084713280 - 20000 46913097296192 - 0 46913101490496 - 0 46913088907584 - 0 46913109879104 - 0 46913105684800 - 0 46913093101888 - 60000 46913118267712 - 70000 46913122462016 - 0 46913034381632 - 4070000 46913126656320 - 7000000 46913130850624 - 320000 46913135044928 - 50000 46913139239232 - 0 46913143433536 - 0 46913147627840 - 0 46913151822144 - 0 46913156016448 - 0 46912895969600 - 7660000 33 record(s) selected.