Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I see the following commands:

  • drop event monitor
  • set event monitor
  • create event monitor

But nothing like list event monitor or get event monitor. Is there a DB2 command to list all current event monitors?

I'm currently using DB2 9.7 but am interested in answers for other versions as well.

share|improve this question

You can query the system catalog table SYSCAT.EVENTMONITORS to get a list of the event monitors defined in your database:

select evmonname, event_mon_state(evmonname) as enabled
  from syscat.eventmonitors

The second column will return 1 for active event monitors, and 0 for inactive event monitors.

This query will work for all versions of DB2 on Linux, UNIX or Windows.

share|improve this answer
Are there any commands that don't include "select"? – Jason Axelson May 8 '13 at 3:43
No. All event monitors are stored in the system catalog. – Ian Bjorhovde May 8 '13 at 4:09

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.