Re: Too many opened files

atkinson@cs.sc.edu (Camelia A Atkinson) wrote: >Any help solving this problem will be greatly appreciated. >Keywords: informix,problems,.dat,.idx >-- >Camelia >~~~~~ >Office : LeConte 119 >Phone : (803)777-5713 >e-mail : atkinson@usceast.cs.sc.edu If this is a UNIX system, the solution is simple. The KERNEL tunning parameters NFILE and NINODE need to be increased. These are system wide maximums for all users combined. Take the maximum number of users multiplied by the maximum number of database tables open at any point in time TIMES 2 (one for the .dat and one for the .idx file). Add some fluff this this number to account for program, temp and other OS files. You will have to relink the kernel and restart the system to make these new setting active. The exact process for this varies depending on the UNIX Vendor. If this is a DOS/WINDOWS system, the problem is more difficult. I know that if the application is using C-ISAM and if you are using Microsoft C that you can increase the maximum number of open file by modifying the "startup code" and increasing the NFILE parameter. Other compiler, or ESQL/C? I don't know. -------------------------------------------------------- Rob McAllister rmcall@on-ramp.ior.com Spokane, WA "On all good programmers a little core must dump"