Re: [Squirrel-sql-users] java.lang.OutOfMemoryError: Java heap space

[Kreig, V. <Viv...@St...>]

Thank you very much Gerd !

My problem was that I wasn't using the Squirrel batch file.  I have 2
GBs of RAM, so now I have increased my JVM to 1200K (this is as high as
I can go).  I suppose this is dependent on the size of my RAM?  I am
able now to run the queries for the smaller result sets.  I am still not
able to run our larger result sets.  Is there any workaround?

Am I on the right version of Java Runtime environment?  Not sure if this
would make any difference. See below.

H:\>java -version
java version "1.3.1_01"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.3.1_01)
Java HotSpot(TM) Client VM (build 1.3.1_01, mixed mode)

Thanks again, at least now I am able to run some of the queries,

Vivian




 -----Original Message-----
From: Gerd Wagner [mailto:ger...@t-...] 
Sent: Wednesday, October 22, 2008 6:57 PM
To: Kreig, Vivian
Cc: squ...@li...
Subject: Re: [Squirrel-sql-users] java.lang.OutOfMemoryError: Java heap
space

Kreig, Vivian wrote:
> Hi,
> I am running a query off our UDB DB2 database and I keep getting
> 'java.lang.OutOfMemoryError: Java heap space'
> 
> My associate who has AQT (Advanced Query Tool) is able to run the
query
> in about a minute ( @ 120K records).  He has the same amount of RAM as
I
> do ( 2 GBs).
> 
> Is there any workaround to this problem?  I googled and found some
tech
> notes regarding tuning the JVM. I'm not exactly sure where I should do
> this.
> 
In your SQuirreL .sh or .bat file you'll find a line like

... /B "%LOCAL_JAVA%w" -Xmx256m -cp %SQUIRREL_CP% ...

or

$JAVA -Xmx256m -cp $TMP_CP ...

In both cases the -Xmx256m says that your JVM is allowed to allocate a
maximum 
amount of 256MB. Just increase the amount to your needs.


Gerd