ISAM Error : Too many files open
User encountered an ISAM "Too many files open" error in Informix and increased the open files limit from 1024 to 100000, but the error persisted. Responders clarified that the OS-level file handle limits must be increased on the database server machine (not the client), not just the application settings. Solutions included checking ulimit for the informix user and modifying system-wide settings via /proc/sys/fs/file-max on Linux.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Any ideas on how to fix this problem? I changed the num of open files setting from 1024 to 100000 and I'm still seeing this error message. Where does Informix create temp files? Thanks!
Hello: Did you change numbe of open files in your operating system? Regards. 2012/7/18, INDIRA NAIR <indira@us.ibm.com>: > Any ideas on how to fix this problem? > I changed the num of open files setting from 1024 to 100000 and I'm still > seeing this error message. Where does Informix create temp files? > Thanks! > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > >
I did change the number of open files on my machine to 100000. Should I be making any changes on the database server??
Which OS are you using? Is your IDS online? 2012/7/18, INDIRA NAIR <indira@us.ibm.com>: > I did change the number of open files on my machine to 100000. Should I be > making any changes on the database server?? > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > >
Indira,
the error is thrown because the database server gets out of file handles.
Normally because of a restriction
in the OS.
Of course you have to change the database server and not the client machine
parameters.
On a UNIX/Linux box the number of open files can be restricted per Login.
So check the ulimit for the user which runs the DB instance.
For Linux (you did not mention your platform ):
cat /proc/sys/fs/file-max to retrieve actual setting
modify systemwide in /etc/sysctl.conf (fs.file-max=100000, as root, after that
sysctl -p to activate settings)
and
# su - informix
$ ulimit -H
$ ulimit -Sshould print the values for user limits.
Hope this helps.
Marcus
----- Ursprüngliche Mail -----
Von: "INDIRA NAIR" <indira@us.ibm.com>
An: ids@iiug.org
Gesendet: Mittwoch, 18. Juli 2012 13:16:54
Betreff: Re: ISAM Error : Too many files open [27639]
I did change the number of open files on my machine to 100000. Should I be
making any changes on the database server??
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
You also have to change the OS's number of open files per process setting. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ 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 Wed, Jul 18, 2012 at 6:42 AM, INDIRA NAIR <indira@us.ibm.com> wrote: > Any ideas on how to fix this problem? > I changed the num of open files setting from 1024 to 100000 and I'm still > seeing this error message. Where does Informix create temp files? > Thanks! > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --14dae9340cad59d6f704c519371b