Question & Answer
Question
In our logs, we can see a LongSqlQueryManagerThreadService WARNING for the following SQL:
update ODMDC.UserSettingIDENTITY set SEQUENCE = SEQUENCE + 1
How to fix this ?
Answer
As recommended in the Tuning Guide for ODM, when using MS SQL you should:
- Prepared Statement cache should be set to 100
- Another optimization is to alter the database with the following command:
• ALTER DATABASE <basename> SET READ_COMMITTED_SNAPSHOT ON;
Regarding this setting (READ_COMMITTED_SNAPSHOT): It does not changes the requirement for isolation level, you still must use: READ COMMITTED.
It changes the internal way the read committed mode works regarding locking mechanism in the Microsoft SQL Server.\
- If the 2 first configuration are not enough apply this property:
Set for Decision Center the configuration parameter string value:
teamserver.concurrencyGateEnabled = false
Product Synonym
ODM
Was this topic helpful?
Document Information
Modified date:
15 June 2026
UID
ibm17266619