DB2 Version 9.7 for Linux, UNIX, and Windows

sort_heap_top - Sort private heap high watermark monitor element

The private sort memory high watermark, in 4 KB pages, across the database manager.

Table 1. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Database Manager db2 Basic
Usage
This element can be used to determine if the SHEAPTHRES configuration parameter is set to an optimal value. For example, if this watermark approaches or exceeds SHEAPTHRES, it is likely that SHEAPTHRES should be increased. This is because private sorts are given less memory whenever SHEAPTHRES is exceeded, and this can adversely affect system performance.
Parent topic: Database system monitor elements