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.

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 | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]