Identifier:db2.db_pct_sort_ovflowed
Database Object Monitored:Database
Category:Sort
Description:Percentage of sorts that overflowed
Equation:100 * (database.sort_overflows / database.total_sorts)
Usage Notes:Sort overflows are sorts that ran out of sort heap and required disk space for temporary storage. These sorts are not efficient, and when this value is consistently high for a number of intervals then it may be necessary to increase the sortheap configuration parameter. If this value is high then you should increase sortheap.