Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2004
    Posts
    1

    Unanswered: How to attack the problem of all sqls are slower after upgrade software stack

    We have recently upgraded software stack and all sqls are slower: total execution time as well as average sql time. Where should I start to find out where the problem lies?

  2. #2
    Join Date
    Jul 2003
    Location
    Austin, TX, USA
    Posts
    278

    Monitoring

    Hi,

    First do a runstats for all your tables. That is a must. Then go ahead and do a reorgchk for all tables and see if the tables need to be reorged.

    Then go ahead and enable snapshot monitors and depending on the snapshot's determine where the system needs more resources. You can use the db2 configuration advisor as a base for the settings and then go ahead and customize them based on the snapshot reports.

    Please specify your db2 version and os version with every post.

    HTH

    Nitin.
    HTH

    Nitin

    Ask the experienced rather than the learned

  3. #3
    Join Date
    Mar 2004
    Location
    Germany
    Posts
    15

    Re: How to attack the problem of all sqls are slower after upgrade software stack

    Originally posted by db2dev
    We have recently upgraded software stack and all sqls are slower: total execution time as well as average sql time. Where should I start to find out where the problem lies?

    Runstats and than Reorg ???

    Reorg/Runstats/Rebind of packages. Than it will work well again.

  4. #4
    Join Date
    Sep 2002
    Posts
    456

    Re: How to attack the problem of all sqls are slower after upgrade software stack

    Everytime you change the code or some hardware, make sure to rebind the packages.

    dollar

    Originally posted by db2dev
    We have recently upgraded software stack and all sqls are slower: total execution time as well as average sql time. Where should I start to find out where the problem lies?

  5. #5
    Join Date
    Mar 2004
    Location
    Germany
    Posts
    15
    Bind ! Rebind can be fatal.

    http://www.db2mag.com/showArticle.jh...cleID=15300107 for more information!

    beste regards

Posting Permissions

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