DB2 10.5 for Linux, UNIX, and Windows

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 diagram
>>-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