FLUSH EVENT MONITOR statement

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

Read syntax diagramSkip visual syntax diagramFLUSHEVENTMONITORevent-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.