SYSCAT.EVENTMONITORS catalog view
Each row represents an event monitor.
|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.|
|TARGET_TYPE||CHAR (1)||Type of target to which event data is written.
|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).
|WRITE_MODE||CHAR (1)||Y||Indicates how this event monitor handles existing event data
when the monitor is activated.
|AUTOSTART||CHAR (1)||Indicates whether this event monitor is to be activated automatically
when the database starts.
|DBPARTITIONNUM1||SMALLINT||This column is deprecated and will be removed in a future release. Replaced by MEMBER.|
|MONSCOPE||CHAR (1)||Monitoring scope.
|EVMON_ACTIVATES||INTEGER||Number of times the event monitor has been activated.|
|NODENUM1||SMALLINT||This column is deprecated and will be removed in a future release. Replaced by MEMBER.|
|DEFINER2||VARCHAR (128)||Authorization ID of the owner of the event monitor.|
|VERSIONNUMBER||INTEGER||Version, release, and modification level in which the event monitor was created or last upgraded.|
|MEMBER||SMALLINT||Number of the member where the event monitor runs and logs events.|
|REMARKS||VARCHAR (254)||Y||Reserved for future use.|