--Monitor log
SELECT * FROM SYSIBMADM.LOG_UTILIZATION WITH UR
Select MEMBER, CUR_COMMIT_DISK_LOG_READS, CURRENT_ACTIVE_LOG, APPLID_HOLDING_OLDEST_XACT from table(mon_get_transaction_log(-1)) as t order by member asc with ur
select APPLICATION_HANDLE,UOW_LOG_SPACE_USED from table(MON_GET_UNIT_OF_WORK(NULL,-1)) where UOW_LOG_SPACE_USED > 0 ORDER BY UOW_LOG_SPACE_USED WITH UR

--Monitor Lock
SELECT HLD_APPLICATION_HANDLE,REQ_APPLICATION_HANDLE,REQ_AGENT_TID, (SELECT VALUE FROM TABLE( MON_FORMAT_LOCK_NAME(LOCK_NAME)) as LOCK WHERE NAME='TABNAME') AS TABNAME FROM TABLE (MON_GET_APPL_LOCKWAIT(NULL, -2))
SELECT LOCK_NAME, SUBSTR(LOCK_OBJECT_TYPE,1,10) LOCK_OBJECT_TYPE, LOCK_MODE, LOCK_CURRENT_MODE, LOCK_WAIT_ELAPSED_TIME, SUBSTR(TABSCHEMA,1,10) TABSCHEMA, SUBSTR(TABNAME,1,10) TABNAME, HLD_APPLICATION_HANDLE, SUBSTR(HLD_APPLICATION_NAME,1,10) HLD_APPLICATION_NAME, SUBSTR(HLD_USERID,1,10) HLD_USERID, LOCK_MODE_REQUESTED, REQ_APPLICATION_HANDLE, REQ_AGENT_TID, SUBSTR(REQ_APPLICATION_NAME,1,20) AS REQ_APPLICATION_NAME, SUBSTR(REQ_USERID,1,20) AS REQ_USERID, REQ_STMT_TEXT, HLD_CURRENT_STMT_TEXT from sysibmadm.MON_LOCKWAITS