The MON_GET_UTILITY table function returns information about utilities currently running on the database.
None
SELECT COORD_MEMBER, APPLICATION_HANDLE AS APPHDL,
SUBSTR(APPLICATION_NAME, 1, 10) AS APPNAME,
SUBSTR(SESSION_AUTH_ID, 1, 10) AS USER,
SUBSTR(UTILITY_DETAIL, 1, 150) AS CMD
FROM TABLE(MON_GET_UTILITY(-2)) AS T
The following result
is output:COORD_MEMBER APPHDL APPNAME USER ...
------------ -------------------- ---------- ---------- ...
0 736 db2bp USER2 ...
0 724 db2bp USER1 ...
... CMD
... ---------------------------------------------------------------------------- ...
... [LOADID: 63.2013-02-01-09.48.42.976823.0 (2;21)] [*LOCAL.user2.130201144359] ...
... [LOADID: 20.2013-02-01-09.43.49.510806.0 (2;20)] [*LOCAL.user1.130201144240] ...
... CMD (continued)
... ----------------------------------------------------------------------------
... OFFLINE LOAD DEL AUTOMATIC INDEXING INSERT COPY NO SCHEMA2.T2
... OFFLINE LOAD DEL AUTOMATIC INDEXING INSERT COPY NO SCHEMA1.T1