RE: Too many open files - Isam error 104

Hi, There are two FD limits in Solaris (Hard and Soft). The hard limit (rlim_fd_max) default and maximum value is 65536 so there is no need to do anything with that, the Soft limit default is 256, add the following to /etc/system and reboot set rlim_fd_cur=4096 (Or a value you are happy with) Regards Colin There are 10 types of people in the world, those that understand binary and those that don't From: jjfahey@gmail.com To: RHabichtsberg@arz-emmendingen.de; informix-list@iiug.org Subject: RE: Too many open files - Isam error 104 Date: Sat, 14 May 2011 14:10:24 -0400 Message body From: John Fahey [mailto:jfahey@mandm.net] Sent: Thursday, May 12, 2011 11:14 PM To: 'Habichtsberg, Reinhard'; 'informix-list@iiug.org' Subject: RE: Too many open files - Isam error 104 Not sure if Solaris supports this; with Linux we put the following in < /etc/security/limits.conf > * soft nofile 131072 * hard nofile 262144 We do a < ulimit –n 256000 > (or so)! in the Bourne shell script we use to start IDS, before we run < oninit > John Fahey From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Habichtsberg, Reinhard Sent: Wednesday, May 11, 2011 7:04 AM To: informix-list@iiug.org Subject: Too many open files - Isam error 104 Hi all,we have an Informix-4ge program that stops with error 104 „too many open files“ while trying to open a violation table. Same program has run for years without this error. The code has not been changed.The schema of two tables has changed:stop violations table for xxx_neu;drop table xxx_neu_vio;drop table xxx_neu_dia;alter table xxx_neu add (verarb_status SMALLINT);start violations table for xxx_neu;set indexes xxx_n_1 filtering;alter table yyy_neu add (anmelde_grund CHAR(2), abmelde_grund CHAR(2), svs67 CHAR(2));Those columns are not in use of the program yet.Parts of the program runs on new application server (Solaris 10 Zone). May be the pogram runs faster than before.The Informix Server is 11.50FC7W3. OS is Solaris 10. We checked some limits on the appservers and the database server host. Ulimit is set to 256 for the appusers and for user informix before starting the databaseserver.We couldn’t see many open files on the appserver. The informix databaseserver has more than 3000 concurrent sessions, most of them ontlitcp connections.What would you suggest?TIA,Reinhard. _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list