Problem dropping table in SE

I have what appears to be a corrupted table in SE. bcheck just hangs forever checking it. dbschema hangs when it hits that table. I tried dropping the table, renaming it, they all hang. Is there a way I can manually remove the table from systables, etc? Any other ideas. It is a data warehouse and I have the data required to reload it, I just don't have a way of getting rid of it. TIA, Tim

On May 4, 7:18 am, timn...@gmail.com wrote: > I have what appears to be a corrupted table in SE. bcheck just hangs > forever checking it. dbschema hangs when it hits that table. I tried > dropping the table, renaming it, they all hang. Is there a way I can > manually remove the table from systables, etc? Any other ideas. It > is a data warehouse and I have the data required to reload it, I just > don't have a way of getting rid of it. > TIA, > Tim Found it. Seems a runaway update statistics was running :-(

I may be wrong - but you can probably just create a new table, then copy the newly generated .idx and .dat over the original corrupt tables.. Make sure you backup your originals... standard disclaimers etc... On Friday 04 May 2007 12:18, timnels@gmail.com wrote: > I have what appears to be a corrupted table in SE. bcheck just hangs > forever checking it. dbschema hangs when it hits that table. I tried > dropping the table, renaming it, they all hang. Is there a way I can > manually remove the table from systables, etc? Any other ideas. It > is a data warehouse and I have the data required to reload it, I just > don't have a way of getting rid of it. > TIA, > Tim > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list -- Mike Aubury Aubit Computing Ltd is registered in England and Wales, Number: 3112827 Registered Address : Murlain Business Centre, Union Street, Chester, CH1 1QP