Db2

  • 1.  Responsiveness Graphich - Logarithm scale ?

    Posted Sun July 05, 2020 08:42 AM
    Hi Team

    I have the feeling that the responsiveness graphic in the summary console page, should use logarithm scale (horizontal bar), instead of linear.

    I understand that this could change a bit from environment to environment,  specially on OLAP/DW dbs.  But I have the feeling that for most OLTP dbs outthere,  the logarith scale should provide a better output.  Or,  make it smart..  change the scale based on the values.

    In this particular case,  I have 6,9k statements running in the 10s->1m range.  But the bar does not even appears. This gives us the false impression that everything is ok.

    Thanks

    ------------------------------
    Samuel Pizarro
    ------------------------------

    #Db2


  • 2.  RE: Responsiveness Graphich - Logarithm scale ?

    Posted Mon July 06, 2020 05:24 AM
    Hi Samuel,

    I agree that logarithm scale is better than linear scale for the horizontal bar, especially when the differences among these values are big. I'll pass the issue to front-end dev to help investigate whether logarithm scale is supported in the UI widget. Will let you know the updates. thanks.

    ------------------------------
    KAI DING
    ------------------------------



  • 3.  RE: Responsiveness Graphich - Logarithm scale ?

    Posted Wed July 08, 2020 02:58 AM
    Hi, Samuel

    Thanks a lot for your great suggestion, and after investigation , we will use logarith scale for xaxis as following:
     

    Thanks!


    ------------------------------
    SHUANG LI
    ------------------------------



  • 4.  RE: Responsiveness Graphich - Logarithm scale ?

    Posted Wed July 08, 2020 09:25 AM

    Ah,.. that's way way way better now!

    Nice.. 

    thanks for the feedback @SHUANG LI



    ------------------------------
    Samuel Pizarro
    ------------------------------



  • 5.  RE: Responsiveness Graphich - Logarithm scale ?

    Posted Sun October 30, 2022 03:48 PM
    Edited by System Fri January 20, 2023 04:29 PM
    Hi @Jason Sizto @SHUANG LI 

    I've noticed that this graph was reverted back to linear scale in the latest releases.. 

    Was this on purpose ??  I really belive log-scales would fit most of the users scenarios..  If somone complained about it  and it was decided to revert it back,  please provide an option to customize it..   Allow the end user to specify a scale for this graoh per connection profile. 


    As you can see,   I have more than 2.8 K statements in the 4th range..  but the bars are "inexistent" 

    Please, could this be reverted back , or at least give us an option to customize it.. 

    Regards



    ​​

    ------------------------------
    Samuel Pizarro
    Db2 DBA
    Kyndryl
    Brazil / Sumaré - SP
    ------------------------------



  • 6.  RE: Responsiveness Graphich - Logarithm scale ?

    Posted Mon October 31, 2022 12:13 PM
    Hi @Samuel Pizarro

    We will investigate and get back to your question.​  Thanks.

    ------------------------------
    Kind Regards,
    Jason Sizto
    ------------------------------



  • 7.  RE: Responsiveness Graphich - Logarithm scale ?

    Posted Fri November 04, 2022 07:54 PM
    Hi @Samuel Pizarro

    Our team will handle this in next DMC release targeting Dec 2022.  Thanks.​​

    ------------------------------
    Kind Regards,
    Jason Sizto
    ------------------------------



  • 8.  RE: Responsiveness Graphich - Logarithm scale ?

    Posted Mon November 07, 2022 07:29 AM

    Hi @Jason Sizto

    Thanks for the feedback!

    ​​

    ------------------------------
    Samuel Pizarro
    Db2 DBA
    Kyndryl
    Brazil / Sumaré - SP
    ------------------------------