Db2

  • 1.  Blocking and waiting connections not shown

    Posted Tue June 16, 2020 07:15 AM
    Hello,

    we use the most current version of the console, i.e. 3.1.1.0, and discovered an issue with the "Blocking and Waiting Connections" view under "Locking".

    Although we can see an entry under "Lockes Objects with Waiting Connections", no entry appears under "Blocking and Waiting Connections". But a query on view "MON_LOCKWAITS" reports these blocking/waiting connections. See the following screenshots. Is this a known issue?


    ------------------------------
    Dirk Fechner
    ------------------------------

    #Db2


  • 2.  RE: Blocking and waiting connections not shown

    Posted Tue June 16, 2020 06:21 PM
    Hello Dirk,

    Yes, this is a known issue in DMC as the existing pruning logic is preventing to show all the blocker and waiter information captured in history in version 3.1.1.  

    The issue is fixed in upcoming DMC 3.1.2 release.

    ------------------------------
    Jason Sizto
    ------------------------------



  • 3.  RE: Blocking and waiting connections not shown

    Posted Tue June 16, 2020 10:40 PM
    Hello Dirk,

    The known issue Jason mentioned is for historical view. But I notice that you're viewing the current records.

    Could you please view the 'Find locked objects' page and do show 'lock status' column(it's hidden as default)? The blocking and waiting records come from the source of 'Find locked objects' page in current design. If you can provide the screen shot of that page, we can check if those records can produce a blocking record.

    Thanks,
    Ke

    ------------------------------
    KE CHEN
    ------------------------------



  • 4.  RE: Blocking and waiting connections not shown

    Posted Wed June 17, 2020 03:55 AM
    Hello Ke,

    you are right, I talked about current records. Currently I cannot reproduce the issue, but I will do as you suggested when the issue occurs again.

    ------------------------------
    Dirk Fechner
    ------------------------------