Hi All,

Can anybody help me in understanding what is the difference between the commands to update the monitor switches ( at switch level and at dbm config level)

1. UPDATE MONITOR SWITCHES

2. UPDATE DATABASE MANAGER

FOR eg

db2 update monitor switches using BUFFERPOOL on

db2 update dbm cfg using bufferpool on


and when to use either of them.


Awaiting for reply.

Regards,
Pushp

Hi Pushp,

For 1. UPDATE MONITOR SWITCHES

To activate any of the local monitor switches use the UPDATE MONITOR SWITCHES command.

The switches will remain active until the application (CLP) detaches, or until they are deactivated with another UPDATE MONITOR SWITCHES command.

2. UPDATE DATABASE MANAGER

It is also possible to manipulate the monitor switches at the database manager level. This involves changing the dft_monswitches parameters in the database manager configuration file, using the UPDATE DBM CFG command.
Whenever a monitoring application is started, it inherits its monitor switch settings from the database manager. Any changes to the database manager's monitor switch settings will not impact any running monitoring applications. Monitoring applications must reattach themselves to the instance to pick up any changes to monitor switch settings.

Functionally both are doing the same thing.

Regards,
Prashant