sap table locked / head lock

[nadav_caridi2]

Dear Experts .

Recently we experience system hangs on our sap clients (teminal) due to database table lock for a long period of time .

Upon looking into the matter I see that there is presumably a select query that blocks other queries

e.g. :

when checking into spid 105 I see that database history has the following query as last run for this session id  :

SELECT [OWTJ].[TimerEtyId],[OWTJ].[Status],[OWTJ].[JobHanConf],[OWTJ].[LastUpdate],[OWTJ].[StartDate],[OWTJ].[StartTime],[OWTJ].[JobHanType],[OWTJ].[Id],[OWTJ].[IsASync] FROM [Dyn2005]..[OWTJ] WHERE [OWTJ].[StartDate] IS NULL  FOR BROWSE

if I kill session 105 (source host is the SAP sql Server )  everything works fine but of course sooner or later same problem occurs.

checking into OWTJ , I don't have any workflow set up for the company

any help is much appreciated.

Thank you ,

Nadav.

[Former Member]

Hi Nadav,

Disallow page locking for those tables. For some tables, disallowing page locks improves the concurrency of accesses from different users to these tables, therefore avoiding deadlocks. You can do this using the SQL command:

EXEC sp_indexoption <tablename>, "DisAllowPageLocks", "TRUE"

Thanks,

Kavitha Rajan.

[nadav_caridi2]

Thank you very much for your reply.

Is this change  permitted under sap service contract?