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

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: > >> Having just added transactions to an SE (5.0?) with 4gl (4.11) engine >> running on SCO UNIX 3.2v4.1, I am now getting error messages. >> >> After taking out the >> transaction BEGIN/COMMIT/ROLLBACK WORK statements, all works fine, with >> the obvious exception that I don't have transaction support anymore. >> >> Error 1: >> >> 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 >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? - Brian G.