Results 1 to 3 of 3

Thread: STMM doubts

  1. #1
    Join Date
    Jun 2006
    Posts
    7

    Unanswered: STMM doubts

    Does STMM try to tune after a db2start??Or does it have a history although the instance is stopped.If it tries to tune after db2start it might impact performance until the tuning is stabilised


    I am trying to understand the cost benefit records in the stmm logs.Can any one help me understand the cost benefit records in the stmm logs

  2. #2
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    It tunes "real time" and has nothing to do with "db2start". It does require an active database. So you have to make sure that your database is constantly active for the best results.

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    STMM 'remembers' the last tuned values and uses them as the starting point after a instance restart.

    HTH

    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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