DB2事件监控器
如何建立事件监控器?db2 "create event monitor dlmon for tables, deadlocks with details write to file 'C:\dlmon'"
如何激活事件监控器?
db2 SET EVENT MONITOR dlmon STATE 1
如何停止事件监控器?
db2 SET EVENT MONITOR dlmon STATE 0
如何查詢监控器的狀態?
db2 SELECT EVMONNAME,EVENT_MON_STATE(EVMONNAME) FROM SYSCAT.EVENTMONITORS
如何刪除事件监控器?
db2 DROP EVENT MONITOR dlmon
页:
[1]