Show TOC

Background documentationMONITOR Statement (monitor_statement) Locate this document in the navigation structure

 

The MONITOR statement (monitor_statement) can be used to initialize counters for monitoring the database with 0.

Structure

Syntax Syntax

  1. <monitor_statement> ::=
  MONITOR INIT
End of the code.
Explanation

The database system always records result counters. These are initialized with 0 when the system is started. The MONITOR statement can be used to reset them to 0.

The event counters recorded by the database system can be retrieved by selecting monitor system tables.

Note Note

For a definition of the monitor system tables, see the Monitor System Tables section of Definition of the System Tables.

End of the note.