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

On Mon, 17 Jul 1995, Sally Woolrich wrote: > 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. > PMJI, but doesn't Informix use "raw" partitions for their DB tables? If so, then only temporary working files would use up locks (FLCKREC). I use the CA-INGRES RDBMS which does use OS files and we've never experienced any problems with per process file limits (MAXUP) or locks. (I suppose an Informix internals expert could clear this up for us.) The SCO default (OSE 3.0) for MAXUP is 25 with a maximum of 200; for FLCKREC it is 100 with a maximum of 500. I have had clients running RealWorld accounting software (Microfocus COBOL) which opens many, many files and hold them open for extended periods; they require setting both MAXUP and FLCKREC to the maximum values allowed. Regards, Lucky Lucky Leavell Phone: (812) 945-6555 Relational Information Systems, Inc. FAX: (812) 949-9233 4727 Grant Line Road Email: ris@iglou.com (Internet) New Albany, IN 47150-2013 71534,2674 (CompuServe) WWW Home Page: http://wl.iglou.com/ris