SAP Knowledge Base Article - Preview

2551649 - DB6: MAXLOCKS reached and unable to grow locklist

Symptom

During processing, you encounter the following error:

2017-01-01-00.00.00.000000+120 E43382132A710        LEVEL: Warning
PID     : 1234             TID : 5678          PROC : db2sysc 0
INSTANCE: db2sid               NODE : 000           DB   : SID
APPHDL  : 0-1                APPID: 127.0.0.1.12345
AUTHID  : SAPSID               HOSTNAME: saphost
EDUID   : 98765                EDUNAME: db2agent (BPQ) 0
FUNCTION: DB2 UDB, lock manager, sqlpCheckAndIncreaseLocklist, probe:1112
DATA #1 : <preformatted>
Attempted to synchronously increase Locklist, but Locklist is not growable at this time
locklist size: 369024
databaseSharedMemorySetSize: 1837072
requestedGrowthBytes: 524288
overflowBytesLeft: 1477115712
additionalBytesForLL: 0

STMM is turned on
DATABASE_MEMORY = AUTOMATIC
LOCKLIST = AUTOMATIC


Read more...

Keywords

SQL0912N, -912, LOCKLIST , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.