How To Fix DB6117 - Anzahl der Sperrerweiterungen pro Stunde

SAP Error Message - Details

• Message type: E = Error

• Message class: DB6 - DB6: Alert Monitoring and Alert Configuration

• Message number: 117

• Message text: Anzahl der Sperrerweiterungen pro Stunde

Was verursacht dieses Problem?

If a transaction accesses the database to make changes, the system
locks exactly those records in the tables that the application is
accessing for the duration of the transaction. The system stores this
information in a separate area of the main memory, and other
transactions can no longer access those records to change them. If this
memory is used up, the entire table is locked from that point on. This
is a lock escalation.

Systemantwort

The table-wide lock obstructs other running transactions and should
generally be avoided.

Wie behebe ich diesen Fehler?

Set the size of the memory area available to an application for locks
using the database parameters LOCKLIST and MAXLOCK.

Fehlermeldungsextrakt aus SAP-System. Copyright SAP SE