Identifier:db2.dbms_post_thresh_sorts
Database Object Monitored:Database Manager Instance
Category:Sort
Description:Number of sorts that requested heaps after sort heap threshold exceeded during the interval
Equation:DELTA(dbms.post_threshold_sorts)
Usage Notes:This type of sort is not as efficient as other types of sorts. If the number is large, then sortheap or sheapthres may need to be adjusted. If this value is high, then increase sheapthres and possibly sortheap.