Troubleshooting
Problem
If you are running DB2 Content Manager Enterprise Edition (prior to the version 8.4.1 Fix Pack 1) on DB2 version 9.5 onwards on Windows, users may receive SQL0930N error. It means that there is not enough storage available to process the statement.
Symptom
The key entry in db2diag.log looks like :
2010-11-18-16.42.10.009000+660 E1652113H736 LEVEL: Error (OS)
PID : 7464 TID : 11684 PROC : db2syscs.exe
INSTANCE: DB2INST1 NODE : 000 DB : SAMPLE
APPHDL : 0-49749 APPID: xx.xx.xx.xx.101118053614
AUTHID : DB2INST1
EDUID : 11684 EDUNAME: db2agent (SAMPLE)
FUNCTION: DB2 UDB, SQO Memory Management, sqloLogMemoryCondition, probe:100
CALLED : OS, -, VirtualAlloc
OSERR : 8 "Not enough storage is available to process this command."
MESSAGE : Private memory and/or virtual address space exhausted
DATA #1 : Requested size, PD_TYPE_MEM_REQUESTED_SIZE, 4 bytes
10616832
DATA #2 : Current set size, PD_TYPE_SET_SIZE, 4 bytes
738000896
2010-11-18-16.42.10.009000+660 E1652113H736 LEVEL: Error (OS)
PID : 7464 TID : 11684 PROC : db2syscs.exe
INSTANCE: DB2INST1 NODE : 000 DB : SAMPLE
APPHDL : 0-49749 APPID: xx.xx.xx.xx.101118053614
AUTHID : DB2INST1
EDUID : 11684 EDUNAME: db2agent (SAMPLE)
FUNCTION: DB2 UDB, SQO Memory Management, sqloLogMemoryCondition, probe:100
CALLED : OS, -, VirtualAlloc
OSERR : 8 "Not enough storage is available to process this command."
MESSAGE : Private memory and/or virtual address space exhausted
DATA #1 : Requested size, PD_TYPE_MEM_REQUESTED_SIZE, 4 bytes
10616832
DATA #2 : Current set size, PD_TYPE_SET_SIZE, 4 bytes
738000896
[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Operating System \/ Hardware - Memory Management","Platform":[{"code":"PF033","label":"Windows"}],"Version":"9.7;9.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
30 April 2025
UID
swg21456869