remvoing statement event moitors

[mumtaz]

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

[Gert van der Kooij]

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>

[mumtaz]

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.