Average Sort Time (ms) - Database

Identifier:db2.db_avg_sort_time

Database Object Monitored:Database

Category:Sort

Description:Average sort time

Equation:database.total_sort_time / database.total_sorts

Usage Notes:At the database level, this value shows the average sort time for all sorts performed by all applications connected to a particular database in the past interval. This value can point to a database with possible sorting problem (for example, applications are spending too much time on sorts). See the SORT screen for this database. You should also look at the sort information for this database manager.