Memory Allocation Failure

Sreenivas · Post by **Sreenivas** » Tue Dec 20, 2005 7:10 am

Hi,

My Job is writing all the error data to an error record and while writing the same it is getting the Message using a Lookup.

I am getting a warning with the following message

"K_FDM84_88_JRNL_LN..lkp_PS_MSG_CAT_ETL_VW: [IBM][CLI Driver] CLI0120E Memory allocation failure. SQLSTATE=HY001"

Can someone shed some light to get out of this warning message.

Thanks,
Sreenivas

ArndW · Post by **ArndW** » Tue Dec 20, 2005 7:24 am

This is a driver message, see IBM Error Messages for details or further reading.

The process cannot allocate additional virtual memory. Is this error sporadic or does it happen every time you try it with this job? If it always happens, is it at the same row?

Sreenivas · Post by **Sreenivas** » Tue Dec 20, 2005 7:35 am

ArndW wrote:This is a driver message, see IBM Error Messages for details or further reading.

The process cannot allocate additional virtual memory. Is this error sporadic or does it happen every time you try it with this job? If it always happens, is it at the same row?

Hi,

Thanks for the response, do you know any settings on the Job side and on the database server side to avoid this problem.

Thanks,
Sreenivas

ArndW · Post by **ArndW** » Tue Dec 20, 2005 7:53 am

The problem hasn't been located yet so no possible solution can be given. You know the DB/2 write is unable to allocate memory; but not why. It could have several causes. First off, try to change your write stage settings to see if the error goes away - and think about the answers to the questions in the previous post; that might help you find the true cause.