ISAM error : too many files open

Posted in 2010

Topics: Error Codes & Troubleshooting, Connectivity: ODBC / JDBC / .NET, Platform-Specific Issues, Java & JDBC Development, Versions, Editions & End-of-Life

Tom Lehr — Mon, 25 Oct 2010 13:42:21 -0700 (PDT) — source: Usenet: comp.databases.informix

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

↪ replying to Tom Lehr

Art Kagel — Mon, 25 Oct 2010 16:50:52 -0400 — source: Usenet: comp.databases.informix

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@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. On Mon, Oct 25, 2010 at 4:42 PM, Tom Lehr <tomcaml@gmail.com> wrote: > 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 > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >

Related threads

Glossary

ISAM error