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
  • CHANGESUMMARY
  • CONN
  • CONNHEADER
  • CONTROL
  • DATAVAL
  • DB
  • DBDBMCFG
  • DDLSTMTEXEC
  • DEADLOCK
  • DLCONN
  • DLLOCK
  • EVMONSTART
  • LOCKING
  • PKGCACHEBASE
  • PKGCACHEDETAILED
  • REGVAR
  • SCMETRICS
  • SCSTATS
  • STMT
  • STMTHIST
  • STMTVALS
  • SUBSECTION
  • SUPERCLASSMETRICS
  • SUPERCLASSSTATS
  • TABLE
  • TABLESPACE
  • THRESHOLDVIOLATIONS
  • TXNCOMPLETION
  • UOW
  • UTILLOCATION
  • UTILPHASE
  • UTILSTART
  • UTILSTOP
  • WCSTATS
  • WLMETRICS
  • 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.
TABOPTIONS VARCHAR (32)   String indicating the logical data group options for the target table. Each character in the string represents an option. Possible values are:
  • E = EXCLUDES
  • I = INCLUDES
  • T = TRUNC
  • Blank = Not applicable