|
Snapshot Level Database Manager |
Logical Data Grouping db2 |
Monitor Switch Basic |
|
Resettable |
Yes |
|
|
Element Name Element Type |
piped_sorts_accepted counter |
Description: The number of piped sorts that have been accepted.
Usage: Each active sort on the system allocates memory, which may result in sorting taking up too much of the available system memory.
When the number of accepted piped sorts is low compared to the number requested, you can improve sort performance by adjusting one or both of the following configuration parameters:
If piped sorts are being rejected, you might consider decreasing your sort heap or increasing your sort heap threshold. You should be aware of the possible implications of either of these options. If you increase the sort heap threshold, then there is the possibility that more memory will remain allocated for sorting. This could cause the paging of memory to disk. If you decrease the sort heap, you might require an extra merge phase that could slow down the sort.
See the Administration Guide for more information on sorts.