Symantec Identity Management

Expand all | Collapse all

Locking on SIB DB tables

  • 1.  Locking on SIB DB tables

    Posted 03-12-2018 03:26 AM

    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



  • 2.  Re: Locking on SIB DB tables

    Posted 03-15-2018 10:46 AM

    Hello Mahe,

     

    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 

     

    Thanks,

    Luke