C-ISAM error -22 resolved

In my original posting I asked about the following isql error: -246: Could not do an indexed read to get the next row. C-ISAM -22: unknown error 166052. Jeffrey F. Lawhorn writes: >I believe the problem is you are running out of disk space where Informix >is writing the temporary table. I'll bet if you check, /tmp (or where >your DBTEMP environment variable points) only has about 15MB of space on >it. Try having DBTEMP point someplace with more space and see if that >fixes your problem. >---- >Jeffrey F. Lawhorn Information Systems Group >Programming Manager Unix, C, and Database Consulting >jeffl@isg.com 450 B Street 16th Floor >sdsu!isg100!jeffl San Diego, CA 92101 (619) 234-3405 x274 I have 23 MB remaining on the disk after the error. Cheryl Gross writes: >Have you changed the ulimit parameter? The ulimit parameter could >be preventing you from accessing/writing a file larger then 15MB. >See ulimit in your system administration manuals. > >The error is a read error. We have gotten that on our 2.10 Informix >"trying" to run Turbo. You might check the set up of Turbo for block >sizes. > >Also, have seen this error listing and talked about when we were >having our trouble as a possible bug with Informix Turbo. I have checked the relevent operating system parameters and they are not limiting. I forgot to mention, we are running SE, not Turbo. Bob Beaulieu writes: >Have you run bcheck on the table/index? Sounds like you may have a corrupted >index. The indexes on the table were indeed corrupt. It required 13 hours to rebuild the indexes on the 103MB data file. Fortunately I had disk space elsewhere so that I could move the table offline to rebuild the indexes since this database supports production and must be available 7 days a week 24 hours a day. The corrupted index is on a static table that has been in existence and used for 2 months. Anyone have any ideas as to why it became corrupted? Thanks for all the thoughts and suggestions. -- - eko __ | | | | ___________________________________________________________ | \\ | | | \\ | Ellen K. Osinski | | | | Hewlett-Packard | \\ \\ | Boise Site Operations - Boise Surface Mount Center | / \\ | 11413 Chinden Blvd | | ---/\\ | Boise, ID 83714-1023 | | | | | | | | phone : (208) 323-4904 | | * | | e-mail: ellen@hpdmmgv.boi.hp.com | | | | telnet: 1-323-4904 | |___________| |___________________________________________________________|