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;
| Segment | Product | Component | Platform | Version | Edition |
|---|---|---|---|---|---|
| Systems and Asset Management | IBM Maximo Asset Management Essentials |
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.