Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2005
    Posts
    118

    Unanswered: MONITOR and Performance

    Hi All !

    With UDB DB2 for Windows (or AIX for some environments)
    What is the general practice with MONITOR SWITCHES ? Do most people have it as OFF for most of the time ? And turn it ON only while tuning the system ? or do you keep the MONITOR SWTICHES ON for LOCK, SORT, BP, UOW, TB, and STATEMENT ?
    I find that we take a tremendous performance hit after turning on all the monitor swithces. It takes for ever to just build a SP.
    Any inputs or words of caution relating to MONITOR SWITCHES ?
    thanks in advance.

    AK

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    You may leave it ON on dev and test instances ...
    When it comes to the prod, you may leave them OFF ... They can be turned ON and OFF dynamically, so shouldn't be a problem ...

    check the documentation of the performance tools you may be using ... The monitor switches may have to be left ON for the tool to work ..
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Feb 2005
    Posts
    118
    Yes, the SWTICHES can be turned on and off dynamically. But the big question is, do you take a performance hit after you turn on the switches. And if yes, which switch has the biggest impact ?

    AK

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    I don't have a definitive answer on which switch has the biggest impact ... But, at times, you may have to turn the monitor switches ON in production to debug/troubleshoot ... that's when you collect the monitor info in prod
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  5. #5
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    You should leave the Timestamp Monitor on at all times. This is the default.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  6. #6
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    If you want to leave the monitor swithces on, you can try to increase the MON_HEAP_SZ value and see if that helps performance. 2048 should be OK.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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