Skip to Content
0
Former Member
May 29, 2013 at 04:35 PM

Frequent CMS (DB2) locks causing slow response and search index freezes

129 Views

Hello Colleagues,

We have BI 4.0 SP5 installed and we are using DB2 as our CMS database. We encounter frequent CMS locks and this is causing platform search index to fail. So we stopped indexing, and we are trying to understand why this behavior occurs.

We have already referred to the following, but it does not seem pertinent for our situation

1640918 - Getting frequent deadlocks in CMS DB pointing to MS
SQL server in BI 4.0

1787321 - database Deadlock warnings in event viewer due to

indexing of search service.


All APS settings are fine tuned to reflect best practices. DSL Bridge @ 6GB, Webi APS @ 6 GB, 4 WebI processing servers on each node.

The question now is how do I prevent database locks in the future. We are unable to run platform search indexing as it causes database locks

Can you please advise us as to how we can fix this problem ?