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 tables E071 and E071K.

The warning means 'DisAllowPageLocks' is set to TRUE in the system. Tables E071 and E071K should not have disallowed 'PAGE locking', the correct setting is FALSE.
MSSPROCS script sap_z_set_parameters shows which tables require disallow 'PAGE locks, 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 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.

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.