Default Database System Monitor Switches (dft_monswitches)

Configuration Type

Database manager

Applies to

• Database Server with local and remote clients
• Database Server with local clients
• Partitioned Database Server with local and remote clients

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

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.)

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]