Ideally, you should set the sort heap threshold (SHEAPTHRES) parameter to a reasonable multiple of the largest SORTHEAP parameter you have in your database manager instance.
理想情况下,应当将排序堆阈值(SHEAPTHRES)参数合理地设置为在数据库管理器实例中设置的SORTHEAP参数最大值的倍数。
Always keep the threshold high enough to fulfill the total sort heap required by all the applications, if not application request for a piped sort will be rejected.
总是要让阈值保持足够大以便满足所有应用程序所需的总排序堆。
The Sort heap Threshold (sheapthres, sheapthres_shr).
排序堆的阈值(sheapthres, sheapthres_shr)。
应用推荐