IBM Support

Reducing locking in Maximo with Row Versioning

Technote (troubleshooting)


Starting with SQL Server 2005, row versioning can reduce or eliminate locking in Maximo.


Database locks are seen in the database.

Resolving the problem

Performance can be improved and locks minimized. This prevents the read

lock from blocking other transactions.

There are some space considerations in tempdb which should be discussed with DBA.

alter database [MX} set single_user with rollback after 120 seconds;
alter database [MX} set read_committed_snapshot on;
alter database [MX} set multi_user;

Cross reference information
Segment Product Component Platform Version Edition
Systems and Asset Management Maximo Asset Management Essentials

Document information

More support for: Maximo Asset Management
System Related

Software version: 6.2, 6.2.1, 6.2.2, 6.2.3, 6.2.4, 6.2.5, 6.2.6, 6.2.7, 6.2.8, 7.1, 7.1.1, 7.5, 7.6

Operating system(s): Windows

Reference #: 1440598

Modified date: 12 July 2010

Translate this page: