Reducing locking in Maximo with Row Versioning

Technote (troubleshooting)


Problem(Abstract)

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

Symptom

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

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

IBM 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

Operating system(s):

Windows

Reference #:

1440598

Modified date:

2010-07-12

Translate my page

Machine Translation

Content navigation