RE: Strange Informix Error messages

I used to get thekse kind of errors on my db too. When update stats is run these errors disappered. May be you could run it on timely basis and observe. Informix DBA MimEcom Corporation 44 Montgomery Street, Suite 2150 San Francisco, CA 94104 415-402-2916 mshevkar@mimecom.com URL: www.mimecom.com "Application & Infrastructure Management (AIM) for E-Businesses" -----Original Message----- From: mars1972@my-deja.com [mailto:mars1972@my-deja.com] Sent: Friday, July 14, 2000 12:06 PM To: informix-list@iiug.org Subject: Re: Strange Informix Error messages You need to find out what the ISAM error code is to fix the problem. This error code is in the sqlca structure, in sqlerrd[1]. I'm not sure how you would reference it using ODBC, I would think you could do a dbinfo(sqlca.sqlerrd1), but I'm not sure. It looks like someone may have an exclusive lock on the table. In article <396f2b39$1_3@corp.newsfeeds.com>, "Nick Palmer" <nick@kcicorp.com> wrote: > Hi all, > > Hopefully someone here can shed some light on some problems we are having. > We are using IDS 7.31 on an HP box (HP/UX 10.20 I believe) and running a > client/server app using the Informix ODBC drivers. Sometimes when we are > using our app, we get the following errors: > > -240 Could not delete a row. > > -243 Could not position within a table table-name. > > -244 Could not do a physical-order read to fetch next row. > > If we perform the same operation again, the error will not come back. The > Informix error guides isn't to helpfull in explaining exactly what the > problem is, except to say that its an ISAM problem. Is there something I > can configure on the server, or maybe in the ODBC driver that would make > these problems go away. Any help would be gratefully appreciated. > > Thanks in advance. > Nick > (nick@kcicorp.com) > > -----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- > http://www.newsfeeds.com - The #1 Newsgroup Service in the World! > -----== Over 80,000 Newsgroups - 16 Different Servers! =----- > -- # unrm / ksh: unrm: not found # man cpio Sent via Deja.com http://www.deja.com/ Before you buy.