SQL Reference

EVENT_MON_STATE

>>-EVENT_MON_STATE--(----string-expression--)------------------><
 

The schema is SYSIBM.

The EVENT_MON_STATE function returns the current state of an event monitor.

The argument is a string expression with a resulting type of CHAR or VARCHAR and a value that is the name of an event monitor. If the named event monitor does not exist in the SYSCAT.EVENTMONITORS catalog table, SQLSTATE 42704 will be returned.

The result is an integer with one of the following values:

• 0

  The event monitor is inactive.

  1

  The event monitor is active.

If the argument can be null, the result can be null; if the argument is null, the result is the null value.

Example:

• The following example selects all of the defined event monitors, and indicates whether each is active or inactive:

     SELECT EVMONNAME,
        CASE
           WHEN EVENT_MON_STATE(EVMONNAME) = 0 THEN 'Inactive'
           WHEN EVENT_MON_STATE(EVMONNAME) = 1 THEN 'Active'
        END
     FROM SYSCAT.EVENTMONITORS