RESET MONITOR command
The RESET MONITOR command 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.
Scope
This command is issued on the currently attached member and, by default, returns information only for that member. In the case of multiple members per host, the currently attached member is the first member that is listed in the db2nodes.cfg file on that host.
To issue the command for a specific member that is not the currently attached member, specify the ATTACH_MEMBER parameter. To issue the command for all members and receive an aggregated result, specify the GLOBAL parameter.
To change the currently attached member, issue the SET CLIENT command with the ATTACH_MEMBER parameter . You must issue the DETACH command followed by the ATTACH command from your application for this change to take effect.
Authorization
- SYSADM
- SYSCTRL
- SYSMAINT
- SYSMON
Required connection
Instance. If there is no instance attachment, a default instance attachment is created.
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
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.
- AT MEMBER member-number
- Specifies the member for which the internal counters are to be reset.
- GLOBAL
- Resets the internal counters for all members in a partitioned database environment or in a Db2® pureScale® environment.
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 member-level counters are reset.
Compatibilities
- DBPARTITIONNUM or NODE can be substituted for MEMBER, except when the DB2_ENFORCE_MEMBER_SYNTAX registry variable is set to ON.