Symptom
Connecting to database fails due to SQL0930N error.
SQL0930N There is not enough storage available to process the statement.
db2diag.log gives following error:
2022-11-05-06.20.08.953074+120 I1481068A437 LEVEL: Severe
PID : 18789 TID : 125 PROC : db2sysc 0
INSTANCE: db2abc NODE : 000
EDUID : 125 EDUNAME: db2sysc 0
FUNCTION: DB2 UDB, oper system services, sqlo_waitlist::initialize, probe:10
MESSAGE : SysV semget failed with errno:
DATA #1 : Hexdump, 4 bytes
0xFFFFFFF251BFDBF4 : 0000 001C
2022-11-05-06.20.08.953302+120 I1481506A439 LEVEL: Severe
PID : 18789 TID : 125 PROC : db2sysc 0
INSTANCE: db2abc NODE : 000
EDUID : 125 EDUNAME: db2sysc 0
FUNCTION: DB2 UDB, oper system services, sqloGetShrEDUWaitElem, probe:70
MESSAGE : waitlist initialization failed, zrc=
DATA #1 : Hexdump, 4 bytes
0xFFFFFFF251BFDC14 : 850F 0081
2022-11-05-06.20.08.953360+120 I1481946A383 LEVEL: Severe
PID : 18789 TID : 125 PROC : db2sysc 0
INSTANCE: db2abc NODE : 000
EDUID : 125 EDUNAME: db2sysc 0
FUNCTION: DB2 UDB, oper system services, sqloEDUEntry, probe:10
DATA #1 : Hexdump, 4 bytes
0xFFFFFFF251BFDF4C : 850F 0081
2022-11-05-06.20.08.953467+120 I1482330A500 LEVEL: Severe
PID : 18789 TID : 24 PROC : db2sysc 0
INSTANCE: db2abc NODE : 000 DB : abc
APPHDL : 0-7 APPID: *LOCAL.db2abc.221104041947
AUTHID : DB2abc
EDUID : 24 EDUNAME: db2agent (abc) 0
FUNCTION: DB2 UDB, global services, sqzEDUObj::StartEDU, probe:10
RETCODE : ZRC=0x870F00F2=-2029059854=SQLO_NORES
"no resources to create process or thread"
Read more...
Environment
- Database: IBM Db2 for LUW
- Operating system: Sun Solaris with version lower than 10 release
Keywords
SQL0930N, SysV semget failed, SQLO_NORES , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , 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.