SQL Reference

SYSCAT.EVENTS

Contains a row for every event that is being monitored. An event monitor, in general, monitors multiple events.

Table 55. SYSCAT.EVENTS Catalog View
Column Name Data Type Nullable Description
EVMONNAME VARCHAR(18)
Name of event monitor that is monitoring this event.
TYPE VARCHAR(18)
Type of event being monitored. Possible values:

DATABASE

CONNECTIONS

TABLES

STATEMENTS

TRANSACTIONS

DEADLOCKS

TABLESPACES

FILTER CLOB(32K) Yes The full text of the WHERE-clause that applies to this event.


[ Top of Page | Previous Page | Next Page ]