Identifier:db2.dbms_pct_pip_srts_acc
Database Object Monitored:Database Manager Instance
Category:Sort
Description:Percentage of piped sorts accepted during the interval
Equation:100 * DELTA(dbms.piped_sorts_accepted) / DELTA(dbms.piped_sorts_requested)
Usage Notes:Piped sorts reduce disk I/O and tend to be more efficient. A high percentage of piped sorts accepted indicates efficient sorts are being performed. A low percentage indicates that sort heap and sort heap threshold may have to be adjusted. If this percentage is low, then increase sheapthres and possibly sortheap.