Identifier:db2.dbms_pct_pip_srts_rej
Database Object Monitored:Database Manager Instance
Category:Sort
Description:Percentage of piped sort requests that were rejected
Equation:100 * (DELTA(dbms.piped_sorts_requested) - 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 low percentage of piped sorts rejected indicates efficient sorts are being performed. A high percentage of piped sorts rejected indicates that sort heap and sort heap threshold may have to be adjusted. If this percentage is high, then increase sheapthres and possibly sortheap.