RE: SE problem

Posted in 1995

Mark Denham — 25 Sep 1995 06:08:03 -0400 — source: Informix-list mailing list archive (1991-1998)

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). Mark Denham BBC London, UK Mark.Denham@bbc.co.uk