享受人生的每一份感動，就是幸福

以下是在AIX環境下，開啟dead lock monitor

先連結到要監控的資料庫
db2 connect to DBNAME

建立event monitor 監控deadlock 並將log 當寫入 /somefolder/dlmon中
db2 "create event monitor DLMONNAME for tables, deadlocks with details write to file '/somefolder/dlmon'

開啟event monitor監控dead lock
db2 "set event monitor DLMONNAME state 1"

關閉event monitor監控dead lock
db2 "set event monitor DLMONNAME state 0"

監控寫出來的log檔，請使用以下方式解開：
db2evmon -path /somefolder/dlmon > /somefolder/dlmon/ dlmon.log