Displaying a list of event monitors created in your database

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

Procedure

To view a list of the event monitors that you defined on your system, query the catalog view SYSCAT.EVENTMONITORS.

For example, to see a list of event monitors that includes the event monitor name, the target output type (that is, a regular table, file, named pipe, or unformatted event table), and the owner, you can use a query such as the following one:

SELECT SUBSTR(EVMONNAME,1,20) AS EVMON_NAME, TARGET_TYPE, OWNER 
FROM SYSCAT.EVENTMONITORS

The preceding query returns results similar to those that follow:

EVMON_NAME           TARGET_TYPE OWNER
-------------------- ----------- -----------------------------------
DB2DETAILDEADLOCK    F           DBADMIN1
CACHEEVMON           T           DBADMIN1
INVTLOCK             T           DBADMIN1
INVTUOW              T           DBADMIN1
INVTACT              T           DBADMIN1
INVTSTATS            T           DBADMIN1
INVTTHRESHOLD        T           DBADMIN1
TABLE_INVTTABLE      T           DBADMIN1
BUFFER_INVT          T           DBADMIN1
TABLESPACES_INVT     T           DBADMIN1
CONNECTIONS_INVT     T           DBADMIN1
TRANSAC_INVT         T           DBADMIN1
DEADLOCK_INVT        T           DBADMIN1
QUINNJN_LOC_UNF      U           DBADMIN1
UNFORM               U           DBADMIN1
RM                   U           DBADMIN1
UOWINVT              U           DBADMIN1
LOCK_UP_STAFF        U           DBADMIN1
INVTLOCK2            T           DBADMIN1
STAFF_UOW            T           DBADMIN1
STAFFSTATS           T           DBADMIN1

  21 record(s) selected.

Examples

You can also use a catalog view to see which event monitors exist for monitoring a specific type of event. The SYSCAT.EVENTS view returns a list of event monitors and the type of events for which they record data.

SELECT SUBSTR(TYPE,1,20) AS EVENT_TYPE, 
   SUBSTR(EVMONNAME,1,20) AS EVENT_MONITOR_NAME 
   FROM SYSCAT.EVENTS 
   ORDER BY TYPE

EVENT_TYPE           EVENT_MONITOR_NAME
-------------------- --------------------
ACTIVITIES           INVTACT
BUFFERPOOLS          BUFFER_INVT
CONNECTIONS          CONNECTIONS_INVT
DEADLOCKS            DEADLOCK_INVT
DETAILDEADLOCKS      DB2DETAILDEADLOCK
LOCKING              INVTLOCK
LOCKING              QUINNJN_LOC_UNF
LOCKING              UNFORM
LOCKING              RM
LOCKING              LOCK_UP_STAFF
LOCKING              INVTLOCK2
PKGCACHEBASE         CACHEEVMON
STATISTICS           INVTSTATS
STATISTICS           STAFFSTATS
TABLES               TABLE_INVTTABLE
TABLESPACES          TABLESPACES_INVT
THRESHOLDVIOLATIONS  INVTTHRESHOLD
TRANSACTIONS         TRANSAC_INVT
UOW                  INVTUOW
UOW                  UOWINVT
UOW                  STAFF_UOW

  21 record(s) selected.