RE: Informix hang
Posted in 2008
Does this application run under tomcat, where are the informix jdbc
files situated, what OS etc.
Do you ensure that when the trasaction is complete, all connections are
closed?
if you run onstat -g ses, is there more connections than are actually
running ie: previous sessions are not closing.
Give us the environment more specifically.
Chaos
-----Original Message-----
From: informix-list-bounces@iiug.org
[mailto:informix-list-bounces@iiug.org] On Behalf Of Obnoxio The Clown
Sent: 28 February 2008 01:20 PM
To: Yaron Reinharts
Cc: informix-list@iiug.org
Subject: Re: Informix hang
Yaron Reinharts said:
> Hi,
>
> We are running a Java application under load which uses Informix JDBC
> driver The Informix server is located on another server
>
> First we tried static connection pool, everything seems to work fine
> however for some reason we can not use static connection pool So, we
> enable dynamic connection pool with the following settings: min = 2,
> max = 50 After ten minutes of load, the Informix server seems to be
> hanged, other clients are not able to connect to it as well The only
> way to recover from this situation is to restart our java application!
>
> Any clue?
Perhaps your logical logs are full?
--
Bye now,
Obnoxio
"There were a myriad of problems which conspired to corrupt your reason
and rob you of your common sense. Fear got the best of you, and in your
panic you turned to the Labour Party. They promised you order, they
promised you peace, and all they demanded in return was your silent,
obedient consent."
--
This message has been scanned for viruses and dangerous content by
OpenProtect(http://www.openprotect.com), and is believed to be clean.
_______________________________________________
Informix-list mailing list
Informix-list@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list