Db2

 View Only
  • 1.  DMC (3.1.9) Locking event montior - Empty ?

    Posted Mon November 14, 2022 02:12 PM
    Edited by System Fri January 20, 2023 04:14 PM

    Query above was execute against the DMC repo..   the event monitor captured the lock events..  

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


  • 2.  RE: DMC (3.1.9) Locking event montior - Empty ?

    Posted Wed November 23, 2022 02:00 AM
    Hi Samuel,

    This is Ke from DMC development team. From the query result, console captured some locks for a connection with internal identifier 1. You need to check if that is the one named 'NoxGR' in your screen shot. Also note that, the timestamp in repo table is in UTC time.

    You can use this query against your repository database to check the internal identifier of connection 'NoxGR'.

    select dbconn_int from IBMCONSOLE.rtmon_map_dbconn where dbconn_id='NoxGR';

    If the 4 records do belong to dbconn_int in the time range you viewed, could you please open a PMR for us to do further investigation? Thanks a lot.

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



  • 3.  RE: DMC (3.1.9) Locking event montior - Empty ?

    Posted Wed November 23, 2022 07:47 AM
    Hi @KE CHEN

    This DMC setup is only monitoring a single dedicated db.  So,  conn = 1 is the only one that exists there. 

    There was only 1 dedlock ocurrence at the database for the entire week.  (captured in db2diag.log) .  I've filtered DMC to show events for the entire week,  day by day,   etc..  but it still does not show the event.

    and , as you could see, the data was capture and saved in the repository table..  but DMC insiste telling nothing happened. 

    I have opened case  TS011330009 for this.  

    Regards ​

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



  • 4.  RE: DMC (3.1.9) Locking event montior - Empty ?

    Posted Wed November 23, 2022 08:45 PM
    Hi Samuel,

    I can see the case. I will reply you in the case. Thanks.

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