Maximo List Archive

This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.



Maximo and Microsoft SQL Server 2005sp3: Locking and Blocking

From: ssc.susser (2011-07-28 17:28)

We were/are having some blocking on our SQL server that was causing denial of service and IBM told us to apply row-level locking on all our tables. Anyone else use MS SQL and have had a blocking problem? Our dba doesn't want to force row-level locking. . . she says that MS SQL is optimized to handle the determination of the lock levels.
Thanks!


From: Chuck Warner (2011-07-28 20:13)

We had similar problems with row locking using SQL server 2005. Changing to row
level locking resolved 90% of the problem.
Also if your Maximo is running slow there is a switch in the properties
application that when running sql server the queries are defaulted to run
against the java instead of the database.
Finally if you’re experiencing dead locks and on version 7.x IBM has a hot fix
to resolve the issue
________________________________
From: ssc.susser <halexander@susser.com>
To: MAXIMO@yahoogroups.com
Sent: Thu, July 28, 2011 1:28:00 PM
Subject: [MAXIMO List] Maximo and Microsoft SQL Server 2005sp3: Locking and
Blocking
 
We were/are having some blocking on our SQL server that was causing denial of
service and IBM told us to apply row-level locking on all our tables. Anyone
else use MS SQL and have had a blocking problem? Our dba doesn't want to force
row-level locking. . . she says that MS SQL is optimized to handle the
determination of the lock levels.
Thanks!