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

In article <3u0ps7$1vf@access5.digex.net> briang@access5.digex.net "Brian G." writes: > <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? You could use the 'fuser' command to check to see just which UNIX files the process (the 'sqlexec' one) has open. Certainly each database table (SE) will be two open files. Regards -- ============================================================================ Sally Woolrich | This mail contains my personal sally@excelsis.demon.co.uk | views not those of my employer! ============================================================================