DB2 Version 9.7 for Linux, UNIX, and Windows

SYSCAT.EVENTMONITORS catalog view

Each row represents an event monitor.

Table 1. SYSCAT.EVENTMONITORS Catalog View
Column Name Data Type Nullable Description
EVMONNAME VARCHAR (128)   Name of the event monitor.
OWNER VARCHAR (128)   Authorization ID of the owner of the event monitor.
OWNERTYPE CHAR (1)  
  • S = The owner is the system
  • U = The owner is an individual user
TARGET_TYPE CHAR (1)   Type of target to which event data is written.
  • F = File
  • P = Pipe
  • T = Table
  • U = Unformatted event table
TARGET VARCHAR (762)   Name of the target to which file or pipe event monitor data is written. For files, it can be either an absolute path name or a relative path name (relative to the database path for the database; this can be seen using the LIST ACTIVE DATABASES command). For pipes, it can be an absolute path name.
MAXFILES INTEGER Y Maximum number of event files that this event monitor permits in an event path. The null value if there is no maximum, or if TARGET_TYPE is not 'F' (file).
MAXFILESIZE INTEGER Y Maximum size (in 4K pages) that each event file can attain before the event monitor creates a new file. The null value if there is no maximum, or if TARGET_TYPE is not 'F' (file).
BUFFERSIZE INTEGER Y Size of the buffer (in 4K pages) that is used by event monitors with file targets; null value otherwise.
IO_MODE CHAR (1) Y Mode of file input/output (I/O).
  • B = Blocked
  • N = Not blocked
  • Null value = TARGET_TYPE is not 'F' (file) or 'T' (table)
WRITE_MODE CHAR (1) Y Indicates how this event monitor handles existing event data when the monitor is activated.
  • A = Append
  • R = Replace
  • Null value = TARGET_TYPE is not 'F' (file)
AUTOSTART CHAR (1)   Indicates whether this event monitor is to be activated automatically when the database starts.
  • N = No
  • Y = Yes
DBPARTITIONNUM SMALLINT   Number of the database partition where the event monitor runs and logs events.
MONSCOPE CHAR (1)   Monitoring scope.
  • G = Global
  • L = Local
  • T = Each database partition on which the table space exists
  • Blank = WRITE TO TABLE event monitor
EVMON_ACTIVATES INTEGER   Number of times the event monitor has been activated.
NODENUM1 SMALLINT   Number of the database partition where the event monitor runs and logs events.
DEFINER2 VARCHAR (128)   Authorization ID of the owner of the event monitor.
REMARKS VARCHAR (254) Y Reserved for future use.
Note:
  1. The NODENUM column is included for backwards compatibility. See DBPARTITIONNUM.
  2. The DEFINER column is included for backwards compatibility. See OWNER.