Re: Memory Allocation Error Accessing iSeries Database

[Scott Klement <midrange-l@xxxxxxxxxxxxxxxx>]

> We are occasionally getting the following error: "[NetManage] [Rumba 
> Data Access] [UPLOADS]Memory Allocation error SQLAllocStmt." We have a 
> job retrieving data from the iSeries. It accesses the iSeries many times 
> a day using SQL statements and normally has no problem.

Sounds like a memory leak in the application.  Under certain circumstances 
(perhaps when a particular error occurs) it sounds like the application 
isn't freeing the handles.

Over time, this'll cause the program to run out of memory, and produce the 
error you've reported.

These types of problems can be difficult to troubleshoot -- especially if 
the failure to free the handle only happens under a particular 
circumstance.  Finding the error can be like finding a needle in a 
haystack!

It could also be a memory leak in the ODBC driver, but somehow I think 
it's more likely to be a bug in the program that uses the driver than in 
the driver itself.

Once the memory has been used up, there's little you can do other than 
reboot (as you've discovered) since the allocations are happening in the 
ODBC engine of the operating system, not in your program itself.  How do 
you free up the memory?  Reboot and start over.

Of course, the real fix is to find the bug in the application and fix it 
so that it no longer has a memory leak :)