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.