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;
显示事务占用的日志量,回滚期间这个值会一直变小。
收起