IBM What are the analyzer.db.updateMode parameter values for Case Foundation Case Analyzer? - United States performance TECHNOTE (FAQ)

QUESTION
 What are the analyzer.db.updateMode parameter values for Case Foundation Case Analyzer? 

ANSWER
The analyzer.db.updateMode parameter controls the JDBC update method used by Case Analyzer when updating tables in the Case Analyzer store SQL database. 

The default value is CUSTOM_BATCH. That means that the JDBC driver will use the CUSTOM_BATCH update method for Case Analyzer queries. 

Another possible value is BATCH. That means that the JDBC driver will use the BATCH update method for Case Analyzer queries. 

You can set the BATCH value for the analyzer.db.updateMode parameter with the following query in the Case Analyzer store database: 

 

 * UPDATE X_CAProperties SET PropValue='BATCH' 
   WHERE PropName ='analyzer.db.updateMode' 


When to set the analyzer.db.updateMode = BATCH setting 
 * IBM support may ask customer to set this setting to circumvent various performance-related symptoms and unexpected behavior. 
 * In general, our experience is that the Microsoft JDBC drivers work better and are more stable with the analyzer.db.updateMode = BATCH setting.
Case Analyzer is not working 

CaseAnalyzer is not working, no latest audit log although service is running

Error in log:

"CAPublisher c2dce3b9 [Error] Unexpected exception occurred while processing task CAPublisher for store CASTORE.; Exception: com.microsoft.sqlserver.jdbc.SQLServerException: The query processor ran out of internal resources and could not produce a query plan. This is a rare event and only expected for extremely complex queries or queries that reference a very large number of tables or partitions. Please simplify the query. If you believe you have received this message in error, contact Customer Support Services for more information."
You can set the BATCH value for the analyzer.db.updateMode parameter with the following query in the Case Analyzer store database: 

 

 * UPDATE X_CAProperties SET PropValue='BATCH' 
   WHERE PropName ='analyzer.db.updateMode'