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.