DB2使用事件监控器

  108.如何建立事件监控器?
  CREATEEVENTMONITORTABLEMONFORTABLESWRITETOFILE'D:TEMP'
  
  109.如何激活事件监控器?
  SETEVENTMONITORTABLEMONSTATE1
  
  110.如何停止事件监控器?
  SETEVENTMONITORTABLEMONSTATE0
  
  111.如何查询监控器的状态?
  SELECTEVMONNAME,EVENT_MON_STATE(EVMONNAME)FROMSYSCAT.EVENTMONITORS

  112.如何删除事件监控器?
  DROPEVENTMONITORTABLEMON
原文地址:https://www.cnblogs.com/ryb/p/427983.html