ISAM error : too many files open

[Tom Lehr]

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(IfxErrMsg.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.java: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

[Art Kagel]

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 (a...@iiug.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.

_______________________________________________
Informix-list mailing list
Inform...@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list