Db2

 View Only
  • 1.  Improvements and corrections for DMC

    Posted Mon July 12, 2021 09:35 AM
    Hello DMC and dmctop Support Team,

    Here are some improvements and corrections for dmctop:

    • Good to see the whole Database size like db2top in t (Tablespaces) Value: DB Size 14.3T/15.3T (example)
    • Tablespace Status as a column in t (Tablespaces) or (Storage - Table space utilization) in dmctop
    • In HADR there is a wrong value for Peer Window: 90000.00s

    Best regards,
    Joachim

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

    #Db2


  • 2.  RE: Improvements and corrections for DMC

    Posted Mon July 19, 2021 07:56 PM
    Edited by System Fri January 20, 2023 04:17 PM
    Hi Joachim,

    Thanks for the feedback! Really appreciate it. For your first suggestion, we have DB Size/Capacity under IO - Table spaces(y) and it is from this query
    SELECT 
    DB_SIZE as DB_SIZE, 
    DB_CAPACITY as DB_CAPACITY 
    FROM 
    SYSTOOLS.STMG_DBSIZE_INFO​
    Can you please check and see if it is what you want? (It might require you to grant EXECUTE permission on SYSTOOLS)

    For tablespace status, there is a column in IO - Table spaces(y) which shows the TBSP_STATE from MON_GET_TABLESPACE . Can you please check if it is what you expect to have?  (https://www.ibm.com/docs/en/db2/11.5?topic=functions-mon-get-tablespace-get-table-space-metrics)

    We will definitely look into HADR value issue.

    Thanks again for your feedback!

    Best,

    ------------------------------
    Yao Wu
    Software Engineer
    IBM
    San Jose CA
    ------------------------------



  • 3.  RE: Improvements and corrections for DMC

    IBM Champion
    Posted Tue July 20, 2021 02:10 AM
    Yao,

    I had never noticed that tablespace capacity appeared on the Tablespace I/O (y) panel.  It would seem to make more sense for it to appear on the Table space utilization page (t), which is showing the total size of each tablespace.


    ------------------------------
    Ian Bjorhovde
    XTIVIA
    Phoenix AZ
    ------------------------------



  • 4.  RE: Improvements and corrections for DMC

    Posted Tue July 20, 2021 03:11 AM
    Hello Yao,

    As Ian wrote I never noticed this value on the Tablespace I/O (y) panel. It's definitely a change design request ;-)
    Also for the tablespace status. But it's good to know that both values are there.

    I believe the Peer Window: 90000.00s is a wrong interpretation from the db cfg paramter HADR_PEER_WINDOW:
    HADR peer window duration (seconds) (HADR_PEER_WINDOW) = 90

    Thanks a  lot and best regards,
    Joachim


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



  • 5.  RE: Improvements and corrections for DMC

    Posted Tue July 20, 2021 06:39 PM
    Hi Ian and Joachim,

    Thanks for pointing that out. We will consider moving it to usage view. We will also focus on improving the documentation for the tool to make users have a better understanding on the metrics of each view. 

    Thanks again for the feedback!

    Best,

    ------------------------------
    Yao Wu
    Software Engineer
    IBM
    San Jose CA
    ------------------------------



  • 6.  RE: Improvements and corrections for DMC

    IBM Champion
    Posted Tue July 20, 2021 07:07 PM

    @Yao Wu – One other area that could use some improvement is the "CPU usage %"​​ metric that's displayed on the Overview screen.

    It appears that dmctop is calculating the percentage of CPU that Db2 has used since db2 started, regardless of whether dmctop is in Delta mode.  This means that for a long-running database, the percentage basically never changes.

    It would be very helpful if CPU usage followed Delta mode – so it could provide instantaneous CPU utilization numbers.

    Thanks!



    ------------------------------
    Ian Bjorhovde
    XTIVIA
    Phoenix AZ
    ------------------------------



  • 7.  RE: Improvements and corrections for DMC

    Posted Tue July 20, 2021 07:18 PM
    Good catch! "CPU usage %" doesn't have delta mode for now.  We will add delta value to this metric in next release.

    Thank you!

    ------------------------------
    Yao Wu
    Software Engineer
    IBM
    San Jose CA
    ------------------------------