Hello Rahul,
thanks for supporting me.
As you can see each partition will be calculated with 1.4TB from the system, but all partitions in summary must have also only 1.TB.
db2 "SELECT MEMBER, MEMORY_TOTAL AS MEMORY_TOTAL FROM TABLE(SYSPROC.ENV_GET_SYSTEM_RESOURCES()) ORDER BY MEMBER"
MEMBER MEMORY_TOTAL
------ --------------------
0 1433600
1 1433600
2 1433600
3 1433600
4 1433600
5 1433600
6 record(s) selected.
db2 "SELECT SUM(MEMORY_TOTAL) AS MEMORY_TOTAL FROM TABLE(SYSPROC.ENV_GET_SYSTEM_RESOURCES())"
MEMORY_TOTAL
--------------------
8601600
1 record(s) selected.
Best regards,
Joachim
------------------------------
Joachim Müller
------------------------------
Original Message:
Sent: Thu June 25, 2020 12:15 PM
From: Rahul Shinge
Subject: High value for System physical Memory in dmctop
Hello Joachim,
Thank you for your question/feedback. This is Rahul from development team. Physical memory is calculated using MEMORY_TOTAL from ENV_GET_SYSTEM_RESOURCES.
I would appreciate if you could send data from your system. Would it be possible to run these partial query on your system?
db2 "SELECT MEMBER, MEMORY_TOTAL AS MEMORY_TOTAL FROM TABLE(SYSPROC.ENV_GET_SYSTEM_RESOURCES()) ORDER BY MEMBER"
db2 "SELECT SUM(MEMORY_TOTAL) AS MEMORY_TOTAL FROM TABLE(SYSPROC.ENV_GET_SYSTEM_RESOURCES())"
Regards,
Rahul Shinge
------------------------------
Rahul Shinge
Managing Consultant
IBM
SAN JOSE CA
Original Message:
Sent: Thu June 25, 2020 10:20 AM
From: Joachim Müller
Subject: High value for System physical Memory in dmctop
Hello DMC Support Team,
First of all a big praise to the developers of this tool. Great work...
When testing the new dmctop console I see a very high value (8.2TB) for System physical Memory. But the system has only 1400.0GB memory. How is this value calculated?
This system is a DPF system with six partitions
Best regards,
Joachim
------------------------------
Joachim Müller
------------------------------
#Db2