Database: Sorts (DB2 UDB for UNIX and
Windows) 
To display information on sorts, call the DBA Cockpit.
...
1. In the navigation frame, choose Performance ® Database.
The Database Snapshot screen appears.
2. Choose Sorts.
|
Field |
Description |
|
Sort Heap |
|
|
Total Size |
Amount of memory in KB available for each sort as defined in the database configuration parameter SORTHEAP (in pages) |
|
Allocated |
Total number of allocated space of sort heap space for all sorts at the level chosen and at the time the snapshot was taken |
|
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. |
|
Active Sorts |
Number of sorts in the database that currently have a sort heap allocated |