Re: RE: SE problem

Mark.Denham@bbc.co.uk (Mark Denham) wrote: > >Giti Khalili wrote: > >>Does INFORMIX-SE (Ver 5.01.UD2, on SunOs 4.1.3) have any limitation >>on the number of open files? > >As per kernel configuration. > >>I have a master table which is refrenced by 170 tables. >>When an update or delete is going to be done on the master table, >>all of the referencing tables will be opened too and it caused >>this error: > >>242: Could not open database table (rosita.ar_t03).>> 24: Too many open files > >>"rosita.ar_t03" is the name of one of my refrencing tables. > >>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. John Prideaux alastl@ix.netcom.com