Re: SE problem

Posted in 1995

Kerry Sainsbury — Wed, 27 Sep 1995 20:12:06 +1200 — source: Informix-list mailing list archive (1991-1998)

In article <446m33$h78@ixnews2.ix.netcom.com>, John Prideaux <alastl@ix.netcom.com> wrote: > Mark.Denham@bbc.co.uk (Mark Denham) wrote: > > > >Giti Khalili wrote: > > > >>I have configured the UNIX kernel with 256 open files. > > > >You need to increase this limit. You have probably not taken into > >account that each index opened will use up a file descriptor. Then > >you have the system catalogs etc. > > > >Also, I am not 100% sure, but I think you get 2 file descriptors opened > >per table (this may be crap). > > From the 7.1 SE Administrator's Guide, SE has a limit of 64 open SE > tables. I cannot imagine that there was no limit before this. 64 tables per sqlexec process (otherwise 128 user licenses are a bit rude!) and I doubt there are many programs that exceed that limit! The 256 limit in the kernal is the total of open tables in *all* sqlexec processes. ------------------------------------,------------------------------------------ Kerry Sainsbury, kerry@kcbbs.gen.nz | THE INFORMIX FAQ v2.2 Mar 95 Quanta Systems, Auckland | kcbbs.gen.nz:/informix/informix.[faq|apx] New Zealand. Work: +64 9 377-4473 | mathcs.emory.edu:/pub/informix/faq/ " " Home: +64 9 279-3571 | http://www.garpac.com/informix.html