SAP Knowledge Base Article - Preview

3230835 - Tables E071 and E071K 'Page locking disallowed' warning in EarlyWatch Alert report.

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

SAP NetWeaver all versions

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.