SAP Knowledge Base Article - Preview

3267264 - DB6: SQL0930N error during database connection

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.