Re: INDEXING PROBLEMS - HELP!!

In article 786920078@sparky, ett@sparky.carleton.ca (E. Todd Taylor) writes: > I'm running an older version of Informix on an Interactive > 5.2.4 Unix. I've been running this application for about > 4 years now and lately I'm getting some strange problems. > > > What can I try next? > > > Much appreciated....Todd (613) 782-2906 > > ett@carleton.ca > > > > I would try the following: 1. unload the table 2. drop the table 3. re-create the table, make sure extent size is set large enough 4. load the data 5. re-create the index(es) 6. run update statistics 7. run your program to see if you get the error again. If you drop the table, any corruption *should* go away with it. I say *should* because I have seen times when it still doesn't go away. But I would still give this a try. If you have the ability, I would try to create this table in a different dbspace that would be using different disks or different parts of disks. good luck! -debbie shelton DBA McCaw Cellular Communications, Inc. debbie.shelton@mccaw.com