How To Fix DB6119 - Anzahl der exklusiven Sperrerweiterungen pro Stunde

SAP Error Message - Details

• Message type: E = Error

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

• Message number: 119

• Message text: Anzahl der exklusiven Sperrerweiterungen pro Stunde

Was verursacht dieses Problem?

If an application accesses database data to make changes, the system
locks exactly those records in the table that are required for the
duration of the transaction. The system stores this information in a
separate area of main memory. In the case of an exclusive lock, other
transactions can no longer access these records even to read them. If
this memory is exhausted, the entire table is locked for reading from
that point on. This is an exclusive lock escalation.

Systemantwort

The table-wide exclusive lock is causing significant obstruction to
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 storing
locks using the database parameters LOCKLIST and MAXLOCK.

Fehlermeldungsextrakt aus SAP-System. Copyright SAP SE