Contains a row for every event monitor that has been defined.
Table 69. SYSCAT.EVENTMONITORS Catalog View
|Column Name||Data Type||Nullable||Description|
||Name of event monitor.|
||Authorization ID of definer of event monitor.|
||The type of the target to which event data is written.
||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.
||The event monitor will be activated automatically when the database
||The number of the partition (or node) on which the event monitor runs and logs events|
|REMARKS||VARCHAR(254)||Yes||Reserved for future use.|
[ DB2 List of Books | Search the DB2 Books ]