环境: db2v9.7, RedHat 5
首先创建一个目录用于存放事件监控，例：
[db2inst1@esi-202 ~]$ mkdir emondir
创建一个sql语句的事件监控
[db2inst1@esi-202 ~]$ db2 "create event monitor emon1 for statements write to file '/home/db2inst1/emondir'"
启动emon1
[db2inst1@esi-202 ~]$ db2 "set event monitor emon1 state 1"
查看事件监控生成的内容：
[db2inst1@esi-202 ~]$db2evmon -path emondir
查看事件监控启动情况：
[db2inst1@esi-202 ~]$db2 "select evmonname, event_mon_state(evmonname) from syscat.eventmonitors
关闭emon1
[db2inst1@esi-202 ~]$ db2 "set event monitor emon1 state 1"
删除emon1
[db2inst1@esi-202 ~]$ db2 "drop event monitor emon1'"
首先创建一个目录用于存放事件监控，例：
[db2inst1@esi-202 ~]$ mkdir emondir
创建一个sql语句的事件监控
[db2inst1@esi-202 ~]$ db2 "create event monitor emon1 for statements write to file '/home/db2inst1/emondir'"
启动emon1
[db2inst1@esi-202 ~]$ db2 "set event monitor emon1 state 1"
查看事件监控生成的内容：
[db2inst1@esi-202 ~]$db2evmon -path emondir
查看事件监控启动情况：
[db2inst1@esi-202 ~]$db2 "select evmonname, event_mon_state(evmonname) from syscat.eventmonitors
关闭emon1
[db2inst1@esi-202 ~]$ db2 "set event monitor emon1 state 1"
删除emon1
[db2inst1@esi-202 ~]$ db2 "drop event monitor emon1'"
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/16582684/viewspace-732150/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
DB2查询数据库大小
请登录后发表评论
登录
全部评论
