How to capture information about the oldest transaction holding the transaction log space?

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;