Results 1 to 5 of 5

Thread: Reset monitor

  1. #1
    Join Date
    May 2005
    Posts
    10

    Question Unanswered: Reset monitor

    I reset all monitors with the command:
    db2 reset monitor all global
    After this, I can see im snapshot, that the values (for example for deadlocks) are reseted.
    But this view I have only in the actuell shell. If I changed the shell I see the old values.
    What can I do to reset all values for every shell?

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    The manual has this to say:
    Each process (attachment) has its own private view of the monitor data. If one user resets, or turns off a monitor switch, other users are not affected. Change the setting of the monitor switch configuration parameters to make global changes to the monitor switches.
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    May 2005
    Posts
    10
    I used the following commands:

    db2 update monitor switches using BUFFERPOOL off
    db2 update monitor switches using lock off
    db2 update monitor switches using sort off
    db2 update monitor switches using STATEMENT off
    db2 update monitor switches using TIMESTAMP off
    db2 update monitor switches using UOW off

    Then I did the same with ON.
    But nothing happend.
    Do you mean something else with turn monitor off? I let all commands exucute as the same user.

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Try reading the usage notes in the manual, where the UPDATE MONITOR SWITCHES command is discussed.
    ---
    "It does not work" is not a valid problem statement.

  5. #5
    Join Date
    May 2005
    Posts
    10
    I think I must restart the dbm and than I will see the new values.
    Tank you.
    Beate

Posting Permissions

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