System Monitor Guide and Reference

RESET MONITOR

Resets the internal database system monitor data areas of a specified database, or of all active databases, to zero. The internal database system monitor data areas include the data areas for all applications connected to the database, as well as the data areas for the database itself.

Authorization

One of the following:

sysadm
sysctrl
sysmaint

Required Connection

Instance or database:

If there is neither an attachment to an instance, nor a connection to a database, a default instance attachment is created.
If there is both an attachment to an instance, and a database connection, the instance attachment is used.

To reset the monitor switches for a remote instance (or a different local instance), it is necessary to first attach to that instance.

Command Syntax

>>-RESET MONITOR------------------------------------------------>
 
>-----+-ALL--+-----+---------------------------------+---------><
      |      '-DCS-'                                 |
      '-FOR--+-----+--+-DATABASE-+---database-alias--'
             '-DCS-'  '-DB-------'

Command Parameters

ALL

This option indicates that the internal counters should be reset for all databases.

FOR DATABASE database-alias

This option indicates that only the database with alias database-alias should have its internal counters reset.

DCS

Depending on which clause it is specified, this keyword resets the internal counters of:

All DCS databases
A specific DCS database.

Usage Notes

Each process (attachment) has its own private view of the monitor data. If one user resets, or turns off a monitor switch, other users are not affected. Change the setting of the monitor switch configuration parameters to make global changes to the monitor switches .

If ALL is specified, some database manager information is also reset to maintain consistency of the returned data, and some node-level counters are reset.

See Also

GET SNAPSHOT

GET MONITOR SWITCHES.

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]