Db2

Db2

Where DBAs and data experts come together to stop operating and start innovating. Connect, share, and shape the AI era with us.


#Data


#Data
#Databases
#Operatingsystems
#Db2
#Databasesolutions
 View Only

  • 1.  High value for System physical Memory in dmctop

    Posted 06/25/20 10:20 AM
    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


  • 2.  RE: High value for System physical Memory in dmctop

    Posted 06/25/20 02:22 PM
    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
    ------------------------------



  • 3.  RE: High value for System physical Memory in dmctop

    Posted 06/26/20 01:14 AM
    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


  • 4.  RE: High value for System physical Memory in dmctop

    Posted 06/26/20 02:33 AM
    Hello Joachim,

    Thanks for the information. Okay total system memory should be ~1.4 TB instead of 8.2TB. We will review and rectify this in upcoming release/fixpack. We will keep you posted.

    Please, can you also provide the following information?
    grep MemTotal /proc/meminfo

    Best Regards,
    Rahul

    ------------------------------
    Rahul Shinge
    IBM
    SAN JOSE CA
    ------------------------------

    Original Message


  • 5.  RE: High value for System physical Memory in dmctop

    Posted 06/26/20 02:44 AM
    Hallo Rahul,

    Thanks a lot for the information.
    grep MemTotal /proc/meminfo won't work, because the monitored system is on AIX.
    Below you see the AIX command to find the real memory.

    lsattr -E -l sys0 | grep realmem
    realmem 1468006400 Amount of usable physical memory in Kbytes False

    Best regards,
    Joachim

    ------------------------------
    Joachim Müller
    ------------------------------

    Original Message


Related Content