应该是db2mtrk是准确的,dbcfg不准确,你可以用select memory_pool_used, memory_pool_used_hwm from table (mon_get_memory_pool(null,null,null)) where memory_pool_type='DATABASE'来查看,这个是准确的,看是不是和db2mtrk相同。The dbheap value that you configure repre...
显示全部应该是db2mtrk是准确的,dbcfg不准确,你可以用
select memory_pool_used, memory_pool_used_hwm
from table (mon_get_memory_pool(null,null,null))
where memory_pool_type='DATABASE'
来查看,这个是准确的,看是不是和db2mtrk相同。
The dbheap value that you configure represents only a portion of the database heap that is allocated. As documented, an extra amount is added to the database heap to account for critical requirements. Therefore, it is normal for database heap memory usage to exceed the user-configured value for the dbheap parameter.
You can monitor your database heap usage by using the MON_GET_MEMORY_POOL table function. For example, the following query:
select memory_pool_used, memory_pool_used_hwm
from table (mon_get_memory_pool(null,null,null))
where memory_pool_type='DATABASE'
Returns the values of memory_pool_used and memory_pool_used_hwm in KB units:
MEMORY_POOL_USED MEMORY_POOL_USED_HWM
-------------------- --------------------
140574 140574
1 record(s) selected.
You can also use the db2pd -db
-mempools command to monitor database heap usage.收起