Time interval to determine deadlock situations

Message type: E = Error

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

Message number: 542

Message text: Time interval to determine deadlock situations



What causes this issue?

A Deadlock is a mutual lock of two or more running transactions. It
means that they are both in a wait state and each is waiting for the
other.
Example:
T1 holds lock A and requires lock B.
T2 holds lock B and requires lock A.
The system resolves this wait situation by resetting one of the
transactions after a certain wait time has expired. The parameter
DLCHKTIME determines this wait time.


System Response

The bigger the value set for the parameter, the longer the deadlock
situations continue and block system operation. Conversely, you should
not set too low a value for the parameter, as identifying deadlocks in
the system can affect performance.


How to fix this error?

If errors occur, correct the parameter using the command:
<LB>UPDATE DB CFG USING DLCHKTIME <value></>

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.


Error message extract from SAP system. Copyright SAP SE.