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

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

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
------------------------------

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
------------------------------

Original Message:
Sent: Wed November 23, 2022 02:00 AM
From: KE CHEN
Subject: DMC (3.1.9) Locking event montior - Empty ?

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
------------------------------

Hi Samuel,

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

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

Original Message:
Sent: Wed November 23, 2022 07:46 AM
From: Samuel Pizarro
Subject: DMC (3.1.9) Locking event montior - Empty ?

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
------------------------------


Original Message:
Sent: Wed November 23, 2022 02:00 AM
From: KE CHEN
Subject: DMC (3.1.9) Locking event montior - Empty ?

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