Identifier:db2.dbms_pct_sort_heap_alloc
Database Object Monitored:Database Manager Instance
Category:Sort
Description:The percentage of the sort heap used during the previous interval.
Equation:100 * (dbms.sort_heap_allocated / dbmsconfig.sheapthres)
Usage Notes:When this value approaches 100% sorts can overflow out of the sort heap. This requires disk space for temporary storage. These sorts are not efficient. Use the percent sort overflowed variable db2.db_pct_sort_ovflowed to see what percentage of your sorts are overflowing. You could also increase sortheap.