Symptom
The EarlyWatch Alert (EWA) Service Report shows that 'PAGE locking' is disallowed for database tables E071 and E071K.
The warning above means 'DisAllowPageLocks' is set to TRUE in the SAP system. Tables E071 and E071K should not have disallowed 'PAGE locking', the correct setting is FALSE.
MSSPROCS script sap_z_set_parameters shows which database tables require disallow 'PAGE locking', see note 1648817.
'DisAllowPageLocks' is a per-table-or-index setting and not a DB setting and should be off (FALSE) for most of the database tables. But the SAP system has some tables that have this options set by the setup to on, e.g. VBDATA and some others.
Execute script sap_z_set_parameters to see which tables require disallow 'PAGE locks (the settings are decided when SWPM runs the MSSPROCS which includes running script sap_z_set_parameters).
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Read more...
Environment
SAP NetWeaver systems based on ABAP or Java stack and Microsoft SQL Server
Product
Keywords
DisAllowPageLocks, Page locking, disallowed, EarlyWatch Alert, EWA, SQL Server, script, sap_z_set_parameters, deadlock , KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , SV-SMG-SER-EWA , EarlyWatch Alert , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.