SELECT
A.APPL_NAME
,T.UOW_ID
,T.APPLICATION_ID
,T.CLIENT_APPLNAME
,CAST( T.UOW_LOG_SPACE_USED / ( 1024 * 1024 ) AS DECIMAL( 20, 2 ) )
AS "LOG_SPACE_USED(MB)"
FROM
TABLE(
MON_GET_UNIT_OF_WORK(
NULL
,-1 ) ) AS T
,SYSIBMADM.APPLICATIONS A
WHERE
A.APPL_ID = T.APPLICATION_ID
ORDER BY
"LOG_SPACE_USED(MB)" DESC;
可以直接查到
收起