Hello all

the developers get this error reported back from their application but
we do not see anything in the message log or any error report at the
OS level.

ErrorCode -104
Message ISAM error: too many files open.
SQLState IX000

StackTrace java.sql.SQLException: ISAM error: too many files open. at
com.informix.util.IfxErrMsg.getSQLException(IfxErr Msg.java:408) at
com.informix.jdbc.IfxSqli.E(IfxSqli.java:3796) at
com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java :2597) at
com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.j ava:2513) at
com.informix.jdbc.IfxSqli.a(IfxSqli.java:1772) at
com.informix.jdbc.IfxSqli.executeExecute

etc etc


Type java.sql.SQLException


If this was a database issue, wouldn't we see something on the
database server or the message log?
they have increased the ulimit on the app server but it does nto
resolve the issue
the version of cold fusion is 10

and the database in informix version 11.fc7 on AIX 5.3


thanks

No, no message in the log for this one usually. The file it can't open is
probably a sort-work file and since it's transitory, the engine doesn't
care. You have to increase the per-process number of open files in the OS
kernel, it's too low.

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
IIUG Board of Directors (art (AT) iiug (DOT) org)

Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.



On Mon, Oct 25, 2010 at 4:42 PM, Tom Lehr <tomcaml (AT) gmail (DOT) com> wrote: