Log使用超过50%，监控两种应用，一个是oldest uncommitted的，另个一个是most log consuming applications
SELECT APPL_ID_OLDEST_XACT FROM SYSIBMADM.SNAPDB 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 DESC WITH UR

APPLICATION_HANDLE   UOW_LOG_SPACE_USED  
-------------------- --------------------
               42808                  458

  1 record(s) selected.

$ db2pd -db txdb -applications 42808 | grep -ip "Applications:"
Applications:
Address            AppHandl [nod-index] NumAgents  CoorEDUID  Status                  C-AnchID C-StmtUID  L-AnchID L-StmtUID  Appid                                                            WorkloadID  WorkloadOccID CollectActData          CollectActPartition     CollectSectionActuals  
0x0780000003170080 42808    [000-42808] 1          10113      UOW-Waiting             0        0          41       1          *LOCAL.db2inst1.151130070500                                     1           49            N                       C                       N  

$ db2pd -db txdb -dynamic anch=41 | grep -ip "Dynamic SQL Statements:"
Dynamic SQL Statements:
Address            AnchID StmtUID    NumEnv     NumVar     NumRef     NumExe     Text
0x0A0001006248FBE0 41     1          0          0          2          2          update employee set salary =
    salary * 1.1

使用shell完成上面的一系列执行和解析，当Log utilization is over 50%，发邮件给DBA Team