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 ?