Troubleshooting
Problem
Slow transactions or apparent hanging during multi-user operations in Maximo applications on Microsoft SQL Server database can result if page locking has not been turned off on the tables and indexes.
Cause
Environment
Resolving The Problem
Connect to the Maximo database using SQL Management Studio. Set the Query output to go to a file, then execute the following statement. This command must be broken onto two lines exactly as shown.
select 'sp_indexoption '''+tablename+''',''AllowPageLocks'',''false'' go'
from maxtable
order by tablename
Set the Query output back to screen.
Select File > Open and read in the file you just created.
Delete the header and row count lines at the top and bottom of the set of commands.
Select Edit > Select All, then click F5 to execute all of the sp_indexoption commands.
This will set page locking off for all tables and their indexes. Once turned off, it will remain off. Maximo Database Configuration application will maintain page locking off if it rebuilds a table or index.
Was this topic helpful?
Document Information
Modified date:
30 December 2019
UID
swg21268567