SELECT CONN.SYSTEM_AUTH_ID AS USER, CONN.APPLICATION_HANDLE AS HANDLE,DAY((current timestamp)-MAX(LOCAL_START_TIME)) CONCAT '+' CONCAT
LPAD(HOUR((current timestamp)-MAX(LOCAL_START_TIME)),2,'0') CONCAT ':' CONCAT
LPAD(MINUTE((current timestamp)-MAX(LOCAL_START_TIME)),2,'0') CONCAT ':' CONCAT
LPAD(SECOND((current timestamp)-MAX(LOCAL_START_TIME)),2,'0') AS RUNTIME,
CAST(STMT_TEXT AS VARCHAR(4096)) AS STATEMENT
FROM TABLE(MON_GET_CONNECTION(NULL,-1)) AS CONN
JOIN TABLE(MON_GET_ACTIVITY(NULL, -2)) AS ACT
ON CONN.APPLICATION_HANDLE = ACT.APPLICATION_HANDLE
WHERE LEFT(CAST(STMT_TEXT AS VARCHAR(4096)),34) != 'SELECT CONN.SYSTEM_AUTH_ID AS USER'
GROUP BY CONN.SYSTEM_AUTH_ID, CONN.APPLICATION_ID, CONN.APPLICATION_HANDLE, CAST(STMT_TEXT AS VARCHAR(4096))
ORDER BY MAX(LOCAL_START_TIME) DESC, SYSTEM_AUTH_ID ASC;

This query will return a list of all of the current queries running on a DB2 system.