Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

NOT ENOUGH STORAGE IS AVAILABLE IN THE "UDF_MEM" HEAP

Posted on 2003-11-10
3
Medium Priority
?
729 Views
Last Modified: 2013-11-15
Hi,
 I hit error below,
SQLSTATE=57011 NOT ENOUGH STORAGE IS AVAILABLE IN THE "UDF_MEM" HEAP TO PROCESS STATEMENT

Any solutions? guess need to increase ''UDF_MEM". How to increase then?

Thanks in advance,
skkl

0
Comment
Question by:soekkwan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 18

Accepted Solution

by:
BigSchmuh earned 80 total points
ID: 9720814
Well, this looks very common in the DB2 world as this dbms is so hard to define its memory usage.
The parameter which define this UDF_MEM heap is a DBM parameter named UDF_MEM_SZ
==> To modify it, open a db2 command line processor and issue:
          UPDATE DBM CFG USING UDF_MEM_SZ=512
You can as well modify it from the ControlCenter using "Configure" menu on your instance.
Whatever the case, you need to stop (db2stop) and restart (db2start) your instance for this new param to be effective.

I think you can check the db2diag.log of your instance BEFORE increasing this parameter as increasing this parameter may not be the good choice if your memory low problem comes from a too big use of memory for private sort (for example)...

Hope this helps.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Storage devices are generally used to save the data or sometime transfer the data from one computer system to another system. However, sometimes user accidentally erased their important data from the Storage devices. Users have to know how data reco…
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…

610 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question