Symptom
1. db2diag.log reports lock list is not growable, (SQL0912N).
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:
2. Issue can occur in phase MAIN_SHDRUN/SUBMOD_SHDPREPEXP/SQLDB_DELPREINT,
In the example below, the issue is with object DDXTT~
SQLDBSCRIPT.SQL' displays
Select on DDNTT~
'SQLDBSCRIPT.OUT':
3 ETQ398XSQL: (MODEFLAG = 'D' and
3 ETQ398XSQL: NOT EXISTS (SELECT TABNAME from "DDNTT~" where
3 ETQ398XSQL: "DDXTT~".TABNAME = "DDNTT~".TABNAME)) )
3 ETQ398XSQL: )
4 ETQ010 Date & Time:
1EETQ008 Error message: dbrc = 99: 'all DB errors, except for ...'
1EETQ009XDB code -912
1EETQ009XSQL0912N The maximum number of lock requests has been reached for the
1EETQ009Xdatabase. Reason code = "1"
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, SQLDBSCRIPT.SQL
, KBA , BC-DB-DB6-INS , Installation SAP System , BC-UPG-TLS-TLA , Upgrade tools for ABAP , 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.
SAP Knowledge Base Article - Preview