Results 1 to 2 of 2

Thread: How t tune ..

  1. #1
    Join Date
    Nov 2003
    Posts
    121

    Unanswered: How t tune ..

    how to tune sortheap and sorthep_thres in conjuctin ?
    any tips.. ?
    to prevent "not enough available sortheap..trying smaller size.."

  2. #2
    Join Date
    Apr 2005
    Posts
    41
    Sortheap is one of those parameters where increasing can have either a negative or positive impact, same goes for decreasing. It sounds like your SORTHEAP : SHEAPTHRES isn't quite correct. The best material to explain is:

    http://www-128.ibm.com/developerwork...l#sortheapsize

    http://www.redbooks.ibm.com/abstract...6432.html?Open

    Graham Martin
    http://www.ibm.com/software/data/db2/migration/

Posting Permissions

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