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.
A partial event record is available at any time 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.