?
Solved

NOT ENOUGH STORAGE IS AVAILABLE IN THE "UDF_MEM" HEAP

Posted on 2003-11-10
3
Medium Priority
?
722 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

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

A Bare Metal Image backup allows for the restore of an entire system to a similar or dissimilar hardware. They are highly useful for migrations and disaster recovery. Bare Metal Image backups support Full and Incremental backups. Differential backup…
This article shows how to use a free utility called 'Parkdale' to easily test the performance and benchmark any Hard Drive(s) installed in your computer. We also look at RAM Disks and their speed comparisons.
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…
This tutorial will walk an individual through the process of installing of Data Protection Manager on a server running Windows Server 2012 R2, including the prerequisites. Microsoft .Net 3.5 is required. To install this feature, go to Server Manager…
Suggested Courses

762 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