=============ORIGINAL MESSAGE==================
>From ashaw@cbnewsg.cb.att.com (andrew.shaw)
Newsgroups: comp.databases.informix
Subject: ESQL/C Online 4 Error -242 Isam -101 help please
Date: 6 Aug 92 16:40:35 GMT
I just experienced an interesting problem that baffles me:
Under Online 4, using ESQL/C, I have prepared an insert
statement for a table. Everything works fine for ~10K
transactions (this insert is only a small part of the
entire transaction). Suddenly, the insert starts failing
with:
-242 Cannot open database table table-name
-101 ISAM error: file is not open
There was another process reading the table when the
problem first started, but it went away and the problem
continued. The table is on the same machine as my insert
process, and was created with LOCK MODE PAGE. My process
has SET LOCK MODE TO WAIT 60, but the error is returned
immediately, so it does not look like a timeout. Can
anyone give me some direction in debugging this problem?
Thanks in advance,
Andrew Shaw
AT&T Bell Labs
shaw@mink.att.com
======================================================
----------------RESPONSE FROM OUT CLOSET ENMGINEER-------------
Andrew it sounds like this could be bug #11923 and/or #11374. I would call
the informix technical support line and reference these two bug numbers
to get further information.
---john
--
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
William Daul Advanced Support INFORMIX SOFTWARE INC.
4100 Bohannon Dr. (415) 926-6488 - wk
Menlo Park, CA. 94025 uunet!infmx!billd or billd@informix.com