IBM Support

Memory parameter calculation on IBM Data Server Manager home page

Question & Answer


Question

How is the memory parameter on IBM Data Server Manager (DSM) home page is calculated

Answer

In DSM, memory in Home page is calculated via DB2 table function MON_GET_MEMORY_POOL with sql as following:
db2 "SELECT varchar(db_name, 20) AS dbname, sum(memory_pool_used), sum(memory_pool_used_hwm) FROM TABLE(MON_GET_MEMORY_POOL(NULL, CURRENT_SERVER, -2)) group by db_name"

The result is in KB and we change it to GB before displaying it on DSM home page.

With MON_GET_MEMORY_POOL, private memory is included in the result.
http://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.5.0/com.ibm.db2.luw.sql.rtn.doc/doc/r0059464.html

To verify, I tried on my environment and the display value is correct:

db2 "SELECT varchar(db_name, 20) AS dbname, sum(memory_pool_used), sum(memory_pool_used_hwm) FROM TABLE(MON_GET_MEMORY_POOL(NULL, CURRENT_SERVER, -2)) group by db_name"

DBNAME 2 3
-------------------- -------------------- --------------------
SAMPLE 239552 257216
- 286080 535168

(239552 + 286080)/1024/1024 = 0.501GB



Also, the same could be confirmed through 'db2top' as well.
Memory in DSM Home page = db2top memory + Private Mem

(11233664+156160)/1024/1024=10.86GB






[{"Product":{"code":"SS5Q8A","label":"IBM Data Server Manager"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"},{"code":"PF002","label":"AIX"}],"Version":"1.1.1;1.1;1.1.2;2.1","Edition":"All Editions","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Product Synonym

DSM

Document Information

Modified date:
16 June 2018

UID

swg21986799