Db2

  • 1.  dmctop Release Frequency

    IBM Champion
    Posted Fri July 10, 2020 10:15 AM

    Hi DMC Support Team,

    I am very pleased with the initial release of dmctop – it addresses many of the issues that existed with dsmtop.  I'm especially happy about being able to reset the baseline, as this was probably the largest deficiency in dsmtop.

    A couple of suggestions / comments:

    1. I'd love to see the menu area re-thought.  It currently takes up the first 37 columns of the terminal window, which is a lot of wasted space.

    2. On the Connections screen, the metrics shown above the list of connections appear with blank lines in between each row of metrics.  This wastes a lot of space (it takes up 20 lines of text to display just 10 lines with data.  This "double spacing" issue appears on other screens as well: I/O - Tablespaces (y), I/O - Tables (Y), and Locks (U)

    3. I love that I can use the arrow keys to highlight lines that I'm interested in.  It would be very convenient if dmctop used the highlighted line as input for the Application Handle (a) or Query Text (L) commands so that you don't have to manually type in the application handle or statement ID manually

    4. I'm hopeful that we'll get the option to filter views again (the '/' key in db2top and dsmtop) – this is extremely helpful for the connections screen, and sometimes on the Dynamic SQL screen.

    Finally, can you provide any insight into the planned release schedule for dmctop?  Will revisions only be released alongside updates to the full DMC, or (as I'm hoping) will it be possible to get more frequent updates (independent of DMC releases)? 


    Thank you!



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

    #Db2


  • 2.  RE: dmctop Release Frequency

    Posted Fri July 10, 2020 01:04 PM
    Edited by System Fri January 20, 2023 04:22 PM

    Hi Ian,

    This Rahul from development team, thanks for your detailed feedback. Some of the items are planned for next release, we will review the remaining items for prioritization.

    dmctop next release planned along with DMC release, please note plan is subject to change.
    Regarding update frequency we need to get back to you after discussing with our product manager.

    We appreciate your valuable feedback
    Best regards,



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



  • 3.  RE: dmctop Release Frequency

    IBM Champion
    Posted Thu September 24, 2020 02:55 PM
    Hello,

    Now that dmctop has been out for a couple of months, I wanted to post a few more observations / critiques / comments in hopes that they might be addressed in the future.

    1. On the Connections screen: I would like to see an Option to filter engine EDUs (db2fw*, db2stmm, db2taskd, etc.) as they are always in EXECUTING state

    2. Bug: The "Reset baseline" pop-up is not modal – it's possible to hit shortcut keys and take focus away from the "Do you want to reset baseline" window, 

    3. Performance: Switching between delta/actual mode can take many seconds to reflect on-screen (i.e. you won't see a change until after the next refresh period). It would be nice if the metrics were refreshed immediately when changing modes.

    4. Usability: Would like the ability to change refresh time without having to quit and restart with different `-i` option

    5. Usability: The column-based view of HADR screen is MUCH harder to read than what's in dsmtop.  If you want to retain a column view, use 1 column for each copy (primary, standby 1, standby 2, standby 3) and work to keep the equivalent elements on the same line for each column.

    6. Bug: When starting dmctop against a local database, there dmctop should not print a warning about SSL (it should only be visible when connecting across the network with -n and -r options)

    7. When filtering large views (like package cache): is the display order factored in to the query (i.e. ORDER BY column FETCH FIRST n ROWS ONLY) ?

    8. Bug: CPU usage % always shows 0.  


    Thanks! 


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



  • 4.  RE: dmctop Release Frequency

    Posted Mon September 28, 2020 01:21 PM
    Hi Ian,

    Thanks for the valuable feedback. We are working on some of the issues that you mentioned, and hopefully they can be addressed in the upcoming release. 

    1. We will hide internal connections on Connections screen and also add filtering feature for table component.

    2. Correct. We noticed this bug in some modals. It should be fixed in next release.

    3. You are right. Currently, we need to wait an extra refresh cycle to see the change. We will look into this issue.

    4. That's really a great suggestion. We will definitely include this feature.

    5. That makes sense. We will reconsider the UI.

    6. Correct, will remove SSL warning when connecting to local database.

    7. In June release version, it doesn't factor to the query. We are bringing in this feature which is when you sort the table, it will affect to the query, in the upcoming release. 

    8.  It's a defect. We are working on it.

    We appreciate your valuable feedback.

    Regards,

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



  • 5.  RE: dmctop Release Frequency

    Posted Fri September 25, 2020 01:21 PM
    Ian, The releases for dmctop are either with a DMC release or with a Db2 release. The latest version of dmctop can be found in the 11.5.5 release. The next one will be along with DMC 3.1.3.

    ------------------------------
    Kanchana Padmanabhan
    ------------------------------