Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Location
    India
    Posts
    30

    Question Unanswered: Diff b/w update monitor switch and update dbm cfg

    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

  2. #2
    Join Date
    Oct 2001
    Location
    Bangalore
    Posts
    186
    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
    Prashant

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •