SAP Knowledge Base Article - Preview

2613576 - DB6: Locklist is not growable at this time

Symptom

2018-01-01-00.00.00.000000-000 E73374118A705        LEVEL: Warning
PID     : 12345              TID : 19791          PROC : db2sysc 0
INSTANCE: db2sid               NODE : 000           DB   : SID
APPHDL  : 0-12                APPID: *LOCAL.db2sid.100000000000
AUTHID  : SAPSID               HOSTNAME: prderpdbnodo1
EDUID   : 12345                EDUNAME: db2agent (SID) 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: 310720
databaseSharedMemorySetSize: 1550176
requestedGrowthBytes: 524288
overflowBytesLeft: 1213464384
additionalBytesForLL: 0


Read more...

Environment

DB2 LUW all versions

For versions 11.1 and higher, reference the following note as well:  
2570778 - DB6: SQL0912N when DB2_AVOID_LOCK_ESCALATION is set to TRUE
If the lock escalation parameter does not resolve the SQL0912N error or you do not wish to remove the parameter, then this KBA will still apply.

Keywords

SQL0912N, MAIN_SHDCRE/SQLDB_ATAB_CLEAN, MAIN_SHDRUN/SUBMOD_SHDPREPEXP/SQLDB_DELPREINT, SUM, SWPM, MAXLOCKS
, KBA , BC-DB-DB6-INS , Installation SAP System , Problem

About this page

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

Search for additional results

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