Solved

NOT ENOUGH STORAGE IS AVAILABLE IN THE "UDF_MEM" HEAP

Posted on 2003-11-10
3
692 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
3 Comments
 
LVL 18

Accepted Solution

by:
BigSchmuh earned 20 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Replication has always been one of those technologies that people run scared from. The main reason is usually cost. When you think of replication, your mind drifts to solutions that replicate from one disk frame to another using block level technolo…
This article is an update and follow-up of my previous article:   Storage 101: common concepts in the IT enterprise storage This time, I expand on more frequently used storage concepts.
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 show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

911 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now