Hi,

I have a Java Program which involves fetching of large volume of data from web service. If the volume of data is so high, I encountered out of memory error.
Error looked like

"Processing Dump Event "systhrow", detail "java/lang/OutOfMemoryError"

So I have set the maximum heap size as 256 MB. Then the program is not throwing out of memory error.

I do insert many records in DB2 table one by one. When the heap size was 256 MB, it throws SQLERRMC : mon_heap_sz from DB2 while inserting few records and few records are not getting inserted..

Please tell me some resolution for this problem. This is of high priority and I am not able to figure out the cause or solution.

Thanks in advance,
Madhu

Talk to your DBA.

What is the reason for this.

I am inserting records one by one. then why is this Heap size not enough problem happening?