Default Database System Monitor Switches (dft_monswitches)

Configuration Type
Database manager

Applies to

Parameter Type
Configurable

Default
All switches turned off

This parameter is unique in that it allows you to set a number of switches which are each internally represented by a bit of the parameter. Depending on the interface you are using to update the database manager configuration, you may be able to update this parameter directly. You may also update each of these switches independently by setting the following parameters:

dft_mon_uow
Default value of the snapshot monitor's unit of work (UOW) switch

dft_mon_stmt
Default value of the snapshot monitor's statement switch

dft_mon_table
Default value of the snapshot monitor's table switch

dft_mon_bufpool
Default value of the snapshot monitor's buffer pool switch

dft_mon_lock
Default value of the snapshot monitor's lock switch

dft_mon_sort
Default value of the snapshot monitor's sort switch

Changes to any of these database system monitor switches take effect immediately; that is, you do not have to stop and restart the database manager.
Note:An existing monitoring application will not automatically use the new default value for a switch. To use the new value (or values), the application must terminate and re-attach to the instance.

Recommendation: Any switch that is turned ON instructs the database manager to collect monitor data related to that switch. Collecting additional monitor data increases database manager overhead which can impact system performance.

All monitoring applications inherit these default switch settings when the application issues its first monitoring request (for example, setting a switch, activating the event monitor, taking a snapshot). You should turn on a switch in the configuration file only if you want to collect data starting from the moment the database manager is started. (Otherwise, each monitoring application can set its own switches and the data it collects becomes relative to the time its switches are set.)