The FLUSH EVENT MONITOR statement writes current database
monitor values for all active monitor types associated with event
monitor event-monitor-name to the event
monitor I/O target. Hence, at any time a partial event record is
available for event monitors that have low record generation frequency
(such as a database event monitor). Such records are noted in the
event monitor log with a partial record identifier.
When
an event monitor is flushed, its active internal buffers are written
to the event monitor output object.
Invocation
This statement can be embedded
in an application program or issued interactively. It is an executable
statement that can be dynamically prepared.
Authorization
The privileges
held by the authorization ID of the statement must include SQLADM
or DBADM authority.
Syntax
>>-FLUSH--EVENT--MONITOR--event-monitor-name--+--------+-------><
'-BUFFER-'
Description
- event-monitor-name
- Name of the event monitor. This is a one-part name. It is
an ordinary identifier.
- BUFFER
- Indicates that the event monitor buffers are to be written out.
If BUFFER is specified, then a partial record is not generated. Only
the data already present in the event monitor buffers are written
out.
Notes
- Flushing out the event monitor will not cause the event monitor
values to be reset. This means that the event monitor record that
would have been generated if no flush was performed, will still be
generated when the normal monitor event is triggered.
- The FLUSH EVENT MONITOR statement does not cause
events to be generated and written for the UNIT OF WORK event monitor.