CA Identity Manager - ver 12.6
IBM WebSphere Application Server - ver 188.8.131.52
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?
Some information on how Identity Manager uses the message engine with WebSphere can be found here.
WebSphere Cluster Installation - CA Identity Manager - 14.1 - CA Technologies Documentation