DB2 8.2.3 (fixpack 10) on AIX, 64 bit.
4 partitions, datawarehouse style environment.
I'm configuring 300000 pages for SORTHEAP and 1.8 mln pages for SHEAPTHRES. Snapshots show that during the batch stream the maximum of only 175000 pages of sort heap are allocated per partition (all private sorts), for a total of just over 700000 pages for the entire database. At the same time there still are sort overflows.
I realize that I may not be able to eliminate overflows altogether, but why DB2 is not using all available sort heap? Are there any other parameters that I need to update along with sortheap/sheapthres?