Re: ESQL/C Problem with more then 62 deletes in transaction

Hi, 62 is rather close to 64, a common value for the number of files open per process. The engine needs stdin and stdout to talk to the application (assuming 5.0x here), leaving 62 descriptors available for tables. Maybe you can reset the limit upwards, either by reconfiguring the kernel or by asking your sysadmin nicely. On my Solaris box, the Korn Shell "ulimit -a" command says: time(seconds) unlimited file(blocks) unlimited data(kbytes) 2097148 stack(kbytes) 8192 coredump(blocks) unlimited nofiles(descriptors) 64 vmemory(kbytes) unlimited If you're using 6.00 or later OnLine, then what I said would not apply. If you're using SE, it would apply to any version. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> Nils.Myklebust@idg.no (Nils Myklebust) wrote: >X-Informix-List-Id: <news.36038> > >You don't give a version, but I am quite sure you hit the same limit >we did in a similar situation. It's something with the number of >tables that can be accessed simultaneously. > >We moved most of the code into stored procedures and got it to work >fine. > >Oliver Heiwig <ohe@sbk-ks.de> wrote: > >:We 've to delete in about 120 Tables, this must be within one >:transaction. But always after 62 Deletes the program make mistakes with >:errorcode -242, independent from the order of the delete statements. >:If I put the statements in 3 transactions each with 40 Tables it works. >: >:Does anybody know a solution?