470,591 Members | 2,005 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

get event monitor state?

Hello list,

Sorry to ask such a stupid question; I am obviously not looking at right
places, but what is the counterpart of set event monitor? There is no
get event monitor and no state column in db2 catalog tables. How do I
know the current state of an event monitor?

TIA

P. Adhia
Aug 2 '06 #1
2 12519
Raj
Try this...
SELECT EVMONNAME,
CASE
WHEN EVENT_MON_STATE(EVMONNAME) = 0 THEN 'Inactive'
WHEN EVENT_MON_STATE(EVMONNAME) = 1 THEN 'Active'
END
FROM SYSCAT.EVENTMONITORS
;

P Adhia wrote:
Hello list,

Sorry to ask such a stupid question; I am obviously not looking at right
places, but what is the counterpart of set event monitor? There is no
get event monitor and no state column in db2 catalog tables. How do I
know the current state of an event monitor?

TIA

P. Adhia
Aug 2 '06 #2
Raj wrote:
Try this...
SELECT EVMONNAME,
CASE
WHEN EVENT_MON_STATE(EVMONNAME) = 0 THEN 'Inactive'
WHEN EVENT_MON_STATE(EVMONNAME) = 1 THEN 'Active'
END
FROM SYSCAT.EVENTMONITORS
;
Perfect.

Thanks
Aug 2 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by datapro01 | last post: by
3 posts views Thread by Dean Earley | last post: by
4 posts views Thread by Raj | last post: by
1 post views Thread by Jo | last post: by
1 post views Thread by vijay.db | last post: by
1 post views Thread by rjha94 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.