Re: How many files does informix open? Was: Re: Wierd SE/Transaction errors-What's happening?

Brian G. (briang@access5.digex.net) wrote: : In article <805380147snz@excelsis.demon.co.uk>, : Sally Woolrich <Sally@excelsis.demon.co.uk> wrote: : >In article <3tq6m2$lqa@access5.digex.net> : > briang@access5.digex.net "Brian G." writes: : >> : >> Program stopped at "arpost.4gl", line number 321. : >> SQL statement error number -211. : >> Cannot read system catalog (sysdepend) . : >> SYSTEM error number -24. : >> Too many open files : >> Hit any key to Continue : ><big snip> : > : >You could have exceeded max. files open per process, which won't show That would be my guess too. : >in 'sar -v' so far as I know, though it DOES show if you are out of UNIX : >locks. : The kernel currently supports 60 open files per process. How many : does the Unix version open to do transactions? I'm only updating two : tables in the code? Well, lets see. There are all the system tables and the indecies that go with them, thats 44 or so in my db. Add the translog file, the 2 tables plus their indecis make 49. Now, INFORMIX needs some temporary files and perhaps an index or too also. That can vary with the size of the tables and the complexity of the query. A set explain, will tell you if indeces are created on the fly. In any case you are only 11 files below limit. Check your $DBTMP (or /tmp) to see what INFORMIX puts out there at when the query starts and perhaps that can solve the mystery. It is NOT uncommon to run out of files/process when running INFORMIX under UNIX. Just rebuild your kernel. Ute : - Brian G. -- --------------------------------------------------------------------------- Life is a game that must be played. The rules of the games are known to us as the Laws of Nature. e-mail: uwillmore@ftc.nrcs.usda.gov