SQL Reference

SYSCAT.EVENTMONITORS

Contains a row for every event monitor that has been defined.
Column Name Data Type Nullable Description
EVMONNAME VARCHAR(18)
Name of event monitor.
DEFINER VARCHAR(128)
Authorization ID of definer of event monitor.
TARGET_TYPE CHAR(1)
The type of the target to which event data is written. Values:

F = File

P = Pipe

TARGET VARCHAR(246)
Name of the target to which event data is written. Absolute pathname of file, or absolute name of pipe.
MAXFILES INTEGER Yes Maximum number of event files that this event monitor permits in an event path. Null if there is no maximum, or if the target-type is not FILE.
MAXFILESIZE INTEGER Yes Maximum size (in 4K pages) that each event file can reach before the event monitor creates a new file. Null if there is no maximum, or if the target-type is not FILE.
BUFFERSIZE INTEGER Yes Size of buffers (in 4K pages) used by event monitors with file targets; otherwise null.
IO_MODE CHAR(1) Yes Mode of file I/O.

B = Blocked

N = Not blocked

Null if target-type is not FILE.
WRITE_MODE CHAR(1) Yes Indicates how this monitor handles existing event data when the monitor is activated. Values:

A = Append

R = Replace

Null if target-type is not FILE.
AUTOSTART CHAR(1)
The event monitor will be activated automatically when the database starts.

Y = Yes

N = No

NODENUM SMALLINT
The number of the partition (or node) on which the event monitor runs and logs events.
MONSCOPE CHAR(1)
Monitoring scope:

L = Local

G = Global

REMARKS VARCHAR(254) Yes Reserved for future use.


[ Top of Page | Previous Page | Next Page ]