The ENV_GET_DB2_EDU_SYSTEM_RESOURCES table function returns system resource metrics at the instance level for all DB2® engine dispatchable units (EDUs).
None
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 - DB2 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. |
SELECT EDU_NAME, DB2_PROCESS_ID
FROM TABLE (ENV_GET_DB2_EDU_SYSTEM_RESOURCES(-2))
This
query returns the following output: 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.
SELECT TID, RESOURCE_METHOD, CPU_USER_TIME_MS
FROM TABLE (ENV_GET_DB2_EDU_SYSTEM_RESOURCES(-2))
This
query returns the following output: 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.