DB2 Version 9.7 for Linux, UNIX, and Windows

SYSCAT.EVENTTABLES catalog view

Each row represents the target table of an event monitor that writes to SQL tables.

Table 1. SYSCAT.EVENTTABLES Catalog View
Column Name Data Type Nullable Description
EVMONNAME VARCHAR (128)   Name of the event monitor.
LOGICAL_GROUP VARCHAR (128)   Name of the logical data group. Possible values are:
  • ACTIVITYHISTORY
  • BUFFERPOOL
  • CONN
  • CONNHEADER
  • CONTROL
  • DATAVAL
  • DB
  • DEADLOCK
  • DLCONN
  • DLLOCK
  • LOCKING
  • PKGCACHEBASE
  • PKGCACHEDETAILED
  • SCSTATS
  • STMT
  • STMTHIST
  • STMTVALS
  • SUBSECTION
  • TABLE
  • TABLESPACE
  • THRESHOLDVIOLATIONS
  • UOW
  • WCSTATS
  • WLSTATS
  • XACT
TABSCHEMA VARCHAR (128)   Schema name of the target table.
TABNAME VARCHAR (128)   Unqualified name of the target table.
PCTDEACTIVATE SMALLINT   A percent value that specifies how full a DMS table space must be before an event monitor automatically deactivates. Set to 100 for SMS table spaces.