Re: Error -245 ISAM -103 - Help

Predrag Jukic (pjukic@ams.edvg.co.at) wrote: : Vadim J. Nikitin wrote: : > : > Hi ! : > : > I have got strange thing. In some stored procedures Informix reports : > "error -245 with ISAM -103 - Cannot position within a file via an index". : > But all indexes are ok. (After dbexport/dbimport database error appears again) : > Trace reports that error occured in FOREACH statements. It's possible to : > create equivalent procedure without error -245, but it's slow enough. : > I use OnLine 5.01 on SCO Unix. Maybe it's known bug ? : > : > WBR, Vadim J. Nikitin. : > : > Please, respond via e-mail, if possible. : I've got the same error in a different situation. : The problem occured with paralel access to a table with a small : number of rows. Since the table was in page-lock mode, the first : access to the small table locked almost the whole index, and a paralel : access was not possible (SQL -245). : A possible way out of this is to : 1) modify the table to row-lock mode AND/OR : 2) set the isolatin level to dirty read : I don't know if 2) is possible with stored procedures. It is......but a less drastic solution is to SET LOCK MODE TO WAIT. You can specify a time limit to wait or wait forever. This is done at the application level. Unless the application otherwise needs to operate with no concurrency control, DIRTY READ should not be an accecptable solution. ___ ___ Principal Consultant / ) __ . __/ /_ ) _ _ __ Informix Software Inc. (303) 850-0210 _/__/ (_(_ (/ / (_(_ _/__) (-' ~/ '(_- 5299 DTC Blvd #740 Englewood CO 80111 dberg@informix.com Opinions expressed herein are my own. Eventually all things merge into one...and a river runs through it. -N.Maclean