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.  Responsiveness Graphich - Logarithm scale ?

    Posted 07/05/20 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 07/06/20 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 07/08/20 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 07/08/20 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 10/30/22 03:48 PM
    Edited by System Admin 01/20/23 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 10/31/22 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 11/04/22 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 11/07/22 07:29 AM

    Hi @Jason Sizto

    Thanks for the feedback!

    ​​

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