Displaying a list of active event monitors in your database

You can see what event monitors are active in your database by using the catalog view SYSCAT.EVENTMONITORS.

Procedure

To view a list of active event monitors for your database, use the EVENT_MON_STATE scalar function to query the catalog view SYSCAT_EVENTMONITORS.

SELECT substr(evmonname, 1, 30) as evmon_name FROM syscat.eventmonitors 
   WHERE event_mon_state(evmonname) = 1

The preceding query returns results similar to those that follow:

EVMON_NAME
------------------------------
DB2DETAILDEADLOCK
MYACTEVMON
MYLOCKEVMON
CACHEEVMON

  4 record(s) selected.