NOT ENOUGH STORAGE IS AVAILABLE IN THE "UDF_MEM" HEAP

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

soekkwanAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

BigSchmuhCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Storage Software

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.