DB2 10.5 for Linux, UNIX, and Windows

DB2 Cancun Release: New monitor elements enhance the monitoring of sort heap memory

Use new monitor elements to better monitor the use of sort heap memory by different applications.

The new monitor elements are as follows:

active_col_vector_consumers
active_col_vector_consumers_top
active_hash_grpbys_top
active_hash_joins_top
active_olap_funcs_top
active_peas
active_peas_top
active_peds
active_peds_top
active_sort_consumers
active_sort_consumers_top
active_sorts_top
post_threshold_col_vector_consumers
sort_consumer_heap_top
sort_consumer_shrheap_top
total_col_vector_consumers

You can size and allocate sort heap memory more efficiently by using these monitor elements with other sort memory monitor elements. You can use the new high watermark monitor elements to identify the heaviest users of sort heap memory, making it easier for you to address potential memory problems.