Db2 On Premise and Cloud

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

    Posted 23 days ago
    Edited by Samuel Pizarro 23 days ago

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

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


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

    Posted 14 days ago
    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 14 days ago
    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 13 days ago
    Hi Samuel,

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

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