Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    63

    Unanswered: SELECTs running slow in 8.1

    We moved from ver 7.2 to ver 8.1 on AIX 5.3.
    This is a 4 node logical partitioned environment on p690.
    The older one was 4 node on SP2 environment.

    But the select queries are running considerably slow on new version than older one.

    Are there any db/dbm parameters to be tuned in 8.1 for optimizing the SELECTs.

    Thanks for help in advance
    toby

  2. #2
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513
    Quote Originally Posted by toby25
    We moved from ver 7.2 to ver 8.1 on AIX 5.3.
    This is a 4 node logical partitioned environment on p690.
    The older one was 4 node on SP2 environment.

    But the select queries are running considerably slow on new version than older one.

    Are there any db/dbm parameters to be tuned in 8.1 for optimizing the SELECTs.

    Thanks for help in advance
    toby
    Yes, lots.

    Do you have your old configuration? Try using those values as a starting point... there are parrallelism parameters, bufferpools, etc that you will want to tune.

    Also - do a REORG/RUNSTATS on everything, if you haven't already.
    --
    Jonathan Petruk
    DB2 Database Consultant

Posting Permissions

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