Db2

  • 1.  Statements - In-flight statements next refresh

    Posted Tue August 04, 2020 04:40 AM
    Hello dmctop Support Team,

    in the pane "Statements - In-flight statements" the interval for the next refresh is 30 seconds.
    Is it possible to set the interval to a lower value?

    I changed the dmctop start command with the -i Refresh interval in seconds parameter for 2 seconds,
    but that didn't changed the next refresh  for the In-flight statements.

    Best regards,
    Joachim

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

    #Db2


  • 2.  RE: Statements - In-flight statements next refresh

    Posted Tue August 04, 2020 05:41 PM
    Hi Joachim,

    Thank you for your feedback. This is Yao from dmctop development team. We set this restriction for the views in statements category due to performance issue. We will definitely improve the performance and remove this restriction in our next release. Apart from this, the shortest refresh interval  is 5 seconds, so you may not be able to set it to 2 seconds. (It will reset to 5s if you set 2s).

    Regards,
    Yao Wu


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



  • 3.  RE: Statements - In-flight statements next refresh

    Posted Wed August 05, 2020 01:24 AM
    Hello Yao,

    Thanks for the answer and the hint with the refresh interval.

    Best regards,
    Joachim

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



  • 4.  RE: Statements - In-flight statements next refresh

    Posted Wed August 05, 2020 02:50 AM
    Hello Yao,

    Small hint:
    When you run dmctop with -u [username] parameter and without the -p [password] parameter - where the password will be prompted - there will no message "Input refresh interval 2 second(s) is smaller than minimum value 5 seconds" occur.

    And another one: 
    On the DB Overview pane CPU usage never changed, always this value is zero.

    Sometimes it is useful to see the hostname, that's what I'm missing and in db2top on the Tablespaces view you see in the last row the database size but that was already missing in dsmtop. These are two valuable values. Perhaps an enhancement for the next release.

    Best regards,
    Joachim



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



  • 5.  RE: Statements - In-flight statements next refresh

    Posted Wed August 05, 2020 03:24 PM
    Edited by System Fri January 20, 2023 04:31 PM
    Hi Joachim,

    1. Thank you for the suggestions. We will add this message in the next release.
    2. For CPU usage metric, we notice this abnormal value as well. We will investigate more on it. Thank you for pointing it out.
    3. Hostname is in the footer area. Not sure if it's what you are looking for.
    4. For the database size on Tablespaces view, we will definitely look into it and add this metric to the view.

    Again, thanks for the valuable feedback. 

    Regards, 
    Yao


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



  • 6.  RE: Statements - In-flight statements next refresh

    Posted Thu August 06, 2020 01:09 AM
    Hello Yao,

    Yes, indeed I found the hostname in the bottom of the DB Overview pane.
    Thanks again for your help.

    Best regards,
    Joachim

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