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?