how can i get current state of event monitor "conn_events"??

xiaomage79 · #1 (**permalink**) 06-03-09, 21:49

db2 => set event monitor conn_events state 1

after that ,how can i get current state of event monitor "conn_events"??

Marcus_A · #2 (**permalink**) 06-04-09, 03:19

Check out the syscat.xxxxxxxx views of the catalog and look for one that has event monitor information. They are documented in the Appendix of the SQL Reference Vol 1.

n_i · #3 (**permalink**) 06-04-09, 08:49

Try "values event_mon_state('CONN_EVENTS')"

coolwinds · #4 (**permalink**) 06-30-09, 10:00

Quote:

select event_mon_state('conn_events') from sysibm.sysdummy1

Quote:

select evmonname, EVENT_MON_STATE(conn_events) as state from syscat.eventmonitors

----------------
Eric Xu (许昌)

Internet Services

Web Development

Digital Marketing

Consumer Tech