SAP Knowledge Base Article - Preview

3199100 - DB6: SQL1221N The Application Support Layer heap cannot be allocated.

Symptom

The SQL1221N error appears in db2diag.log file:

PID : 27441 TID : 865 PROC : db2sysc 0
INSTANCE: db2<sid> NODE : 000 DB : <sid>
APPHDL : 0-573 APPID: *LOCAL.DB2.210102141055
AUTHID : DB2<sid> HOSTNAME: <host name>
EDUID : 865 EDUNAME: db2stmm (<sid>) 
CHANGE : STMM CFG DB <sid> : "Database_memory" From: "78096768" <automatic> To: "115523409" <automatic>
...
2020-01-04-10.26.00.389934+480 E550354733A554 LEVEL: Error
PID : 27447 TID : 7567 PROC : db2acd 0
INSTANCE: db2<sid> NODE : 000
HOSTNAME: <host name>
EDUID : 7567 EDUNAME: db2acd 0
FUNCTION: DB2 UDB, Administrative Task Scheduler, AtsTask::run, probe:200
MESSAGE : ZRC=0xFFFFFB3B=-1221
SQL1221N The Application Support Layer heap cannot be allocated.
DATA #1 : <preformatted>
[IBM][CLI Driver] SQL1221N The Application Support Layer heap cannot be allocated. SQLSTATE=57011


Read more...

Environment

  • SAP on IBM Db2 for LUW
  • OS: HP-UX

Keywords

SQL1221N, SHMSEG, SHMMNI , KBA , sql1221n, shmseg, shmmni , BC-DB-DB6-DBA , Database Administration , 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.