Shulou(Shulou.com)06/02 Report--

Environment: db2v9.7, RedHat 5

First, create a directory to store event monitoring, for example:

[db2inst1@esi-202 ~] $mkdir emondir

Create an event monitor for a sql statement

[db2inst1@esi-202 ~] $db2 "create event monitor emon1 for statements write to file'/ home/db2inst1/emondir'"

Start emon1

[db2inst1@esi-202 ~] $db2 "set event monitor emon1 state 1"

View the content generated by event monitoring:

[db2inst1@esi-202 ~] $db2evmon-path emondir

View event monitoring startup:

[db2inst1@esi-202 ~] $db2 "select evmonname, event_mon_state (evmonname) from syscat.eventmonitors

Close emon1

[db2inst1@esi-202 ~] $db2 "set event monitor emon1 state 1"

Delete emon1

[db2inst1@esi-202 ~] $db2 "drop event monitor emon1'"

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.