Memory / Database Memory Pools
Purpose
Database memory pools view shows the list of memory pools. This view is helpful to visualize the usage of memory pool of each memory set.
Screenshot
Metric shown
Gauge
Memory % of HWM
The percentage of the highest amount of memory assigned to this pool since it was created over total amount of committed memory.
= MEMORY_POOL_USED_HWM / MEMORY_POOL_USED
Source:
MEMORY_POOL_USED_HWM = MON_GET_MEMORY_POOL(‘DATABASE’, NULL, #MEMBER#).SUM(MEMORY_POOL_USED_HWM)
MEMORY_POOL_USED = MON_GET_MEMORY_POOL(‘DATABASE’, NULL, #MEMBER#).SUM(MEMORY_POOL_USED)
Sort heap % of HWM
The percentage of the highest amount of shared sort memory assigned to this pool since it was created over total amount of committed shared sort memory.
= SHARED_SORT_MEMORY_USED_HWM / SHARED_SORT_MEMORY_USED
Source:
SHARED_SORT_MEMORY_USED_HWM = MON_GET_MEMORY_POOL(‘DATABASE’, NULL, #MEMBER#).SUM(MEMORY_POOL_USED_HWM) WHERE MEMORY_POOL_TYPE = ‘SHARED_SORT’
SHARED_SORT_MEMORY_USED = MON_GET_MEMORY_POOL(‘DATABASE’, NULL, #MEMBER#).SUM(MEMORY_POOL_USED) WHERE MEMORY_POOL_TYPE = ‘SHARED_SORT’
MEMORY_POOL_TYPE = MON_GET_MEMORY_POOL(‘DATABASE’, NULL, #MEMBER#).MEMORY_POOL_TYPE
Sort heap % of HWM
The percentage of max amount of committed memory skewed from average.
= (MAX(SUM_MEMORY) - AVG(SUM_MEMORY)) / MAX(SUM_MEMORY)
Source:
SUM_MEMORY = MON_GET_MEMORY_POOL(‘DATABASE’, NULL, #MEMBER#).MEMORY_POOL_USED
Grid
Self tuning
Whether self tuning is on or off.
SELECT (CASE WHEN SUBSTR(VALUE,1, 2) = 'ON' then 'On' ELSE 'Off' END)FROM SYSIBMADM.DBCFGWHERE NAME = 'self_tuning_mem' and MEMBER= 0
Source: SYSIBMADM.DBCFG
Table
Memory set
The type of memory set.
= (<MEMORY_SET_TYPE>)
Source: MON_GET_MEMORY_POOL(NULL, CURRENT_SERVER, #MEMBER#).MEMORY_SET_TYPE
Memory pool
The name of the memory pool.
Source: MON_GET_MEMORY_POOL(NULL, CURRENT_SERVER, #MEMBER#).MEMORY_POOL_TYPE
Application handle
A system-wide unique ID for the application. Only applicable to APPLICATION, STATISTICS, STATEMENT, and SORT_PRIVATE memory pool types. Otherwise, the value is NULL.
Source: MON_GET_MEMORY_POOL(NULL, CURRENT_SERVER, #MEMBER#).APPLICATION_HANDLE
Mem set used
The amount of memory from this set that has been assigned to memory pools.
Source: MON_GET_MEMORY_SET(NULL, CURRENT_SERVER, #MEMBER#).MEMORY_SET_USED
Mem set committed
The amount of memory currently committed to this memory set.
Source: MON_GET_MEMORY_SET(NULL, CURRENT_SERVER, #MEMBER#).MEMORY_SET_COMMITTED
Additional committed mem
The amount of memory currently committed to this memory set but has not been assigned to memory pools.
= MEMORY_SET_COMMITTED - MEMORY_SET_USED
Source:
MEMORY_SET_COMMITTED = MON_GET_MEMORY_SET(NULL, CURRENT_SERVER, #MEMBER#).MEMORY_SET_COMMITTED
MEMORY_SET_USED = MON_GET_MEMORY_SET(NULL, CURRENT_SERVER, #MEMBER#).MEMORY_SET_USED
Memory pool used
Amount of committed memory in use by this memory pool.
Source: MON_GET_MEMORY_POOL(NULL, CURRENT_SERVER,#MEMBER#).MEMORY_POOL_USED
Memory used hwm
The highest amount of memory assigned to this pool since it was created.
Source: MON_GET_MEMORY_POOL(NULL, CURRENT_SERVER,#MEMBER#).MEMORY_POOL_USED_HWM
Percent of total mem %
The percentage of the amount of committed memory in use by this memory pool.
= MEMORY_POOL_USED / SUM(MEMORY_POOL_USED)
Source: MEMORY_POOL_USED = MON_GET_MEMORY_POOL(NULL, CURRENT_SERVER,#MEMBER#).MEMORY_POOL_USED
Number of pools
The total number of memory pools.
Automatic
Provides specific information for the configuration parameter current value. Valid values are:
- NONE - no additional information
- AUTOMATIC - the configuration parameter has been set to automatic
- COMPUTED - the configuration parameter has been set to a computed value
Source: SYSIBMADM.DBCFG.MIN(VALUE_FLAGS)
Db config name
DB configuration parameter name.
Source: SYSIBMADM.DBCFG.NAME
Db config value
The current value of the configuration parameter stored in memory.
Source: SYSIBMADM.DBCFG.VALUE
Sortable name
The string to sort the memory pool.
= <MEMORY_SET_TYPE >.<MEMORY_POOL_TYPE >
Source:
MEMORY_SET_TYPE = MON_GET_MEMORY_POOL(NULL, CURRENT_SERVER,#MEMBER#).MEMORY_SET_TYPE
MEMORY_POOL_TYPE = MON_GET_MEMORY_POOL(NULL, CURRENT_SERVER, #MEMBER#).MEMORY_POOL_TYPE