Snapshot Level Database Manager Database |
Logical Data Grouping db2 dbase |
Monitor Switch Basic Basic |
Resettable |
No |
|
Element Name Element Type |
sort_heap_allocated gauge |
Description: The total number of allocated pages of sort heap space for all sorts at the level chosen and at the time the snapshot was taken.
Usage: The amount of memory allocated for each sort may be some or all of the available sort heap size. Sort heap size is the amount of memory available for each sort as defined in the database configuration parameter sortheap.
It is possible for a single application to have concurrent sorts active. For example, in some cases a SELECT statement with a subquery can cause concurrent sorts.
Information may be collected at two levels:
Normal memory estimates do not include sort heap space. If excessive sorting is occurring, the extra memory used for the sort heap should be added to the base memory requirements for running the database manager. Generally, the larger the sort heap, the more efficient the sort. Appropriate use of indexes can reduce the amount of sorting required.
You may use the information returned at the database manager level to help you tune the sheapthres configuration parameter. If the element value is greater than or equal to sheapthres, it means that the sorts are not getting the full sort heap as defined by the sortheap parameter.