Troubleshooting
Problem
Symptom
FUNCTION: DB2 UDB, SQO Memory Management, sqlocshr, probe:180
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
CALLED : OS, -, shmat OSERR: EINVAL (22)
Due to the random nature of the address space layout, these failures can occur randomly.
Various commands can encounter this problem, including db2pd, db2egcf, db2vend and db2fmp.
Exceeded re-exec max count trying to attach to the database manager. This is likely due to ASLR currently being enabled on this system. Please retry the db2pd command.
The db2egcf process (used for HA monitoring) might incorrectly determine that the instance is down and initiate a failover.
SQL2043N Unable to start a child process or thread.
The db2fmp process (used for fenced UDFs and stored procedures) might fail with an error:
$ db2 "SELECT T.RESULT FROM T1, TABLE(MYUDF(T1.C1)) AS T"
RESULT
------------------------
SQL0430N User defined function "MYUDF" (specific name "SQL123456789012345") has abnormally terminated. SQLSTATE=38503
Log InLog in to view more of this document
Was this topic helpful?
Document Information
Modified date:
16 June 2026
UID
swg21365583