468,101 Members | 1,420 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,101 developers. It's quick & easy.

remvoing statement event moitors

I set up a few statement event monitors from CLP. How can I list all the
statement event monitors and remove them. They do not show up in control
centre, and I know they exist because when I try to set a new statement
event monitor with a name that I used before, it gives me an error
message saying that event monitor already exists.

Any ideas ?

thanks

- mumtaz
Nov 12 '05 #1
2 1333
In article <dj**********@rumours.uwaterloo.ca>, mumtaz
(ma*******@hotmail.com) says...
I set up a few statement event monitors from CLP. How can I list all the
statement event monitors and remove them. They do not show up in control
centre, and I know they exist because when I try to set a new statement
event monitor with a name that I used before, it gives me an error
message saying that event monitor already exists.

Any ideas ?

thanks


From the CLP run the command
db2 select evmonname from syscat.eventmonitors

Drop the event monitors with
db2 drop event monitor <evmonname>

Nov 12 '05 #2
Gert van der Kooij wrote:
In article <dj**********@rumours.uwaterloo.ca>, mumtaz
(ma*******@hotmail.com) says...
I set up a few statement event monitors from CLP. How can I list all the
statement event monitors and remove them. They do not show up in control
centre, and I know they exist because when I try to set a new statement
event monitor with a name that I used before, it gives me an error
message saying that event monitor already exists.

Any ideas ?

thanks

From the CLP run the command
db2 select evmonname from syscat.eventmonitors

Drop the event monitors with
db2 drop event monitor <evmonname>


Thanks.
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by jbaker | last post: by
6 posts views Thread by Radith Silva | last post: by
2 posts views Thread by nekiv90 | last post: by
7 posts views Thread by gordon | last post: by
6 posts views Thread by tshad | last post: by
1 post views Thread by Solo | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.