I'm trying to insert about 30000 records on 10 tables in Cloudscape 10.1 using both Bulk Import and classic Inserts.
I tried to set PageCache according to this Derby Document http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0408bradbury/#cs_OutOfMem
but I'm still having Out of Memory while Inerting.
My JVM MaxHeap is -Xmx40m Cloudscape Pagecachesize = 40 and PageSize = 4096; I think I'm using the lower values possible; Afeter inserting the half of records I get the OOM error!!!
I'm working with IBM J9 vm on Windows CE. My App uses 8MB and the memory available on the device is 70mb.
What else can I do to make my application run???
Thanks in Advance for your Help
This topic has been locked.
1 reply Latest Post - 2007-03-19T17:58:35Z by Stan
Pinned topic OOM while performing lots of INSERT Statements on PDA
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2007-03-19T17:58:35Z at 2007-03-19T17:58:35Z by Stan
Stan 120000HAGM267 PostsACCEPTED ANSWER
Re: OOM while performing lots of INSERT Statements on PDA2007-03-19T17:58:35Z in response to SystemAdminHi -
I haven't worked with Derby in minimal environments like this so can't speak from experience what maxHeap setting might work. Focusing on the error: the OOM indicates that the JVM, your application and Derby combined need more than the 40Mb the JVM has available to allocate. Try increasing the memory allocated to the JVM (-Xmx) to see if you can get the process to complete. I have always been told not to set this higher than the amount of physical memory of the device.
Also, if you are not using 10.2.2 it would be good to upgrade to insure you have the benefits of the most recent fixes in the codeline. Adding more physical memory so a higher maxHeap can be set would, of course, help resolve problems if the OOMs continue.
The derby-user mail list at Apache might be a good place to raise the issue of running Derby on PDAs. I did a quick search and there have been a few posts about Derby on PDAs but nothing specific about memory or configurations. The Derby-users could offer you advice from their experience.