Spotlight on DB2 6.10 - Release Notes

Piped Sorts Rejected

The number of piped sort requests that were rejected. A piped sort is rejected if the sort heap threshold is exceeded at the time the sort heap is allocated. Increasing the SHEAPTHRES for the instance or the SORTHEAP for the database can increase piped sort acceptance.

Note: In a multiple-partition database, information is presented for each active partition on the system. An All Nodes row keeps a running total for all partitions. In a single-partition database, only the All Nodes information is presented.