Displays the status of the database system monitor switches. Monitor switches instruct the database system manager to collect database activity information. Each application using the database system monitor interface has its own set of monitor switches (see GET MONITOR SWITCHES). A database manager-level switch is on when any of the monitoring applications has turned it on. This command is used to determine if the database system monitor is currently collecting data for any monitoring application.
Authorization
One of the following:
Required Connection
Instance or database:
To display the settings for a remote instance, or for a different local instance, it is necessary to first attach to that instance.
>>-GET--+-DATABASE MANAGER-+---MONITOR SWITCHES----------------><
+-DB MANAGER-------+
'-DBM--------------'
Command Parameters
None
Examples
The following is sample output from GET DATABASE MANAGER MONITOR SWITCHES:
DBM System Monitor Information Collected
Buffer Pool Activity Information (BUFFERPOOL) = ON 06-11-1997 10:11:01.738377
Lock Information (LOCK) = OFF
Sorting Information (SORT) = ON 06-11-1997 10:11:01.738400
SQL Statement Information (STATEMENT) = OFF
Table Activity Information (TABLE) = OFF
Unit of Work Information (UOW) = ON 06-11-1997 10:11:01.738353
|
Usage Notes
The six recording switches (BUFFERPOOL, LOCK, SORT, STATEMENT, TABLE, and UOW) are off by default, but may be switched on using UPDATE MONITOR SWITCHES. If a particular switch is on, this command also displays the time stamp for when the switch was turned on.
For a summary of all database monitor data elements and monitoring groups, see the System Monitor Guide and Reference.
See Also