SYSCAT.EVENTS catalog view

Each row represents an event that is being monitored. An event monitor, in general, monitors multiple events.

Table 1. SYSCAT.EVENTS Catalog View
Column Name Data Type Nullable Description
EVMONNAME VARCHAR (128)   Name of the event monitor that is monitoring this event.
TYPE VARCHAR (128)   Type of event being monitored. Possible values are:
  • ACTIVITIES
  • CHANGEHISTORY
  • CONNECTIONS
  • DATABASE
  • DEADLOCKS
  • DETAILDEADLOCKS
  • DLOCKWHIST
  • DLOCKWHISTAVAL
  • LOCKING
  • PKGCACHEBASE
  • PKGCACHEDETAILED
  • STATEMENTS
  • TABLES
  • TABLESPACES
  • THRESHOLDVIOLATIONS
  • TRANSACTIONS
  • STATISTICS
  • UOW
FILTER CLOB (64K) Y Full text of the WHERE clause that applies to this event.