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;
|Systems and Asset Management||IBM Maximo Asset Management Essentials|