Db2

 View Only
Expand all | Collapse all

DMC Alerts (Application connections with excessive lock waits over request time)

  • 1.  DMC Alerts (Application connections with excessive lock waits over request time)

    Posted Tue January 31, 2023 09:13 AM

    Hi DMC community

    I am new here and trying to get into DMC.

    I have a question about the alert messages "Application connections with excessive lock waits over request time".

    I have noticed a lot of messages with this alerts that I cannot explain. In my screenshot (attachment) you can see what I mean.

    How can it be that total-requested-time of 0 seconds and lock-waited-for-locks with 0 seconds produce a warning for lock-wait-time-percentage 52% ?

    Is it a rounding error and the internal calculation is done in milliseconds? Have you an idea how I can handle this issue? Because I do not want to disable this alert completely.



    Regards
    Roman



    ------------------------------
    Roman Welk
    ------------------------------


  • 2.  RE: DMC Alerts (Application connections with excessive lock waits over request time)

    Posted Wed February 22, 2023 09:25 AM

    I have the same problem with some of these alerts. Can someone suggest a solution or workaround for this?



    ------------------------------
    Bujji Phanikiran Vanjarapu
    ------------------------------

    Original Message