事件监控器

建立事件监听器
db2 "create event monitor dlmon for tables, deadlocks with details write to file 'C:\dlmon'"
mkdir C:\dlmon

启用事件监听器
db2 "set event monitor dlmon state 1"

删除事件监听器
db2 "drop event monitor dlmon"

分析监听结果
db2evmon -path c:\dlmon > c:\dlmon\dllog1.txt

查看事件监听器状态
db2 select evmonname, EVENT_MON_STATE(evmonname) as state from syscat.eventmonitors