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.  Improvements and corrections for DMC

    Posted 07/12/21 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 07/19/21 07:56 PM
    Edited by System Admin 01/20/23 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

    Posted 07/20/21 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
    ------------------------------

    Original Message


  • 4.  RE: Improvements and corrections for DMC

    Posted 07/20/21 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
    ------------------------------

    Original Message


  • 5.  RE: Improvements and corrections for DMC

    Posted 07/20/21 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
    ------------------------------

    Original Message


  • 6.  RE: Improvements and corrections for DMC

    Posted 07/20/21 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 07/20/21 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
    ------------------------------

    Original Message


Related Content