You can capture information about the oldest transaction holding the
transaction log space by using SYSPROC.MON_GET_UNIT_OF_WORK () and
SYSPROC.MON_GET_TRANSACTION_LOG () table functions and the SQL statement is as listed below:
SELECT MONGETUOW.MEMBER, SUBSTR (MONGETUOW.WORKLOAD_OCCURRENCE_STATE, 1, 20) AS "STATUS", SUBSTR (MONGETUOW.SESSION_AUTH_ID, 1, 10) AS "AUTHID", MONGETUOW.APPLICATION_HANDLE AS "APPL_HANDLE", INTEGER (MONGETUOW.UOW_LOG_SPACE_USED/1024/1024) AS "LOG_USED_MB", (MONGETUOW.TOTAL_ACT_TIME/1000) AS "TOTAL_ACTIVITY_TIME_SEC", (MONGETUOW.TOTAL_ACT_WAIT_TIME/1000) AS "TOTAL_ACTIVITY_WAIT_TIME_SEC", MONGETUOW.UOW_START_TIME AS "UOW_START_TIME" FROM TABLE (MON_GET_TRANSACTION_LOG (-2)) AS MONGETTLOG, TABLE (MON_GET_UNIT_OF_WORK (NULL,-2)) AS MONGETUOW WHERE MONGETUOW.APPLICATION_HANDLE = MONGETTLOG.APPLID_HOLDING_OLDEST_XACT;