AnsweredAssumed Answered

Locking on SIB DB tables

Question asked by MaheCA on Mar 12, 2018
Latest reply on Mar 15, 2018 by najlu01

Hi,

 

CA Identity Manager - ver 12.6

IBM WebSphere Application Server - ver 8.5.5.9

Red Hat Enterprise Linux Server release 6.9

SQL Server 2014

 

We are having 2 CA Identity Manager instances deployed in IBM WebSphere Application servers of "PROD-A" and "PROD_B" servers. (LINUX) under the SAME cluster

 

Buses > IMS_Bus > Messaging engines > IDM_PROD_IMS_Bus

 

Last week, we had an issue stating that:

"SIBOWNERO" DB table is locked by the transaction initiated from the host "PROD_A"

"SIBOWNER" DB table is locked by the transaction initiated from the host "PROD_B"

 

The locks remained for more than 4+ days.

 

As per my understanding, these 2 DB tables are available in "Websphere Messaging  Bus Database" and they are used by the messaging engines in BUS of IBM WAS.

 

How CA Identity Manager's functionalities depend on this messaging engine?

 

Thanks,

Mahe

Outcomes