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.  Statements - In-flight statements next refresh

    Posted 08/04/20 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 08/04/20 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 08/05/20 01:24 AM
    Hello Yao,

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

    Best regards,
    Joachim

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

    Original Message


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

    Posted 08/05/20 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
    ------------------------------

    Original Message


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

    Posted 08/05/20 03:24 PM
    Edited by System Admin 01/20/23 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
    ------------------------------

    Original Message


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

    Posted 08/06/20 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
    ------------------------------

    Original Message


Related Content