Skip to Content
0
Dec 15, 2006 at 09:42 AM

ADM5501I lock escalation

297 Views

Hello,

can somebody explain the lock escalation to me?

We had the following problem.

The system hangs for 5 Minutes. In the diaglog we can see many entries like this:

ADM5501I DB2 is performing lock escalation. The total number of locks

currently held is "156", and the target number of locks to hold is "78". The

current statement being executed is "DELETE FROM "REGUH" WHERE "MANDT" = ?

AND "LAUFD" = ? AND "LAUFI" = ? AND "XVORL" = ? -- OPTLEVEL( 5 ) --

QUERY_DEGREE( 1 ) -- LOCATION( SAPLF110 , 242 ) -- SYSTEM( PIP , SAPR3 )".

^^

2006-12-15-09.15.47.994711 Instance:db2pip Node:000

PID:561288(db2agent (PIP) 0) TID:1 Appid:*LOCAL.db2pip.061214030638

data management sqldEscalateLocks Probe:3 Database:PIP

This repeats with several other tables.

At the end only this tables are mentioned:

DB6PMSA_AG, DB6PMSA_ST,DB6PMSA

Thanks in advance

Jan