Applications: Sorts (DB2 UDB for UNIX and Windows) 

To display information on sorts for your selected application(s), call the DBA Cockpit.

...

       1.      In the navigation frame, choose Performance ®Applications.

The Application Snapshot screen appears.

       2.      To display more detailed information, select one or more applications and choose  Details.

A detail Application Snapshot screen appears.

       3.      Choose Sorts.

If you have selected more than one application, you can use the page buttons on the screen to navigate between them.

Field	Description
Sort Time
Total	Total time in milliseconds required for all sort processes
Average	Average sort time in milliseconds
Sorts
Total Sorts	Total number of sorts that have been executed
Sort Overflows	If the storage area allocated for sorting is not large enough, a sort overflow occurs. The hard disk is then used temporarily.