Contains a row for every event monitor that has been defined.
Table 69. SYSCAT.EVENTMONITORS Catalog View
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| EVMONNAME | VARCHAR(18) |
| Name of event monitor. |
| DEFINER | CHAR(8) |
| 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=ReplaceNull 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. |