Re: Corrupt sysindexes.

In article <34a7fd24.1225524408@news.mindspring.com>, Mike South <msouth@mindspring.com> writes > > >I have a database that was rarely used but recently when I tried to >access it, it owuld immediatetly crash the server on connecteing. > >The problem turned out to be a corrupt index on the systables table, >tabname to be exact. Repairing the index would crash the server, OK I >dont need the databse anyway so I try to drop it...NOPE crashes the >server. OK I go into sysindexes and delete the index from the table. >Still can't drop the database, cant rename it either...Anybody got any >ideas on how to get rid of it. > Talk to Informix Technical Support. >I tried restoring back to 30 days...but the index was corrupted even >then. All I want to do is get rid of the database. BTW there are >other databases in the dbspace that I do need....Wouldn't database >level restores be nice..... > >DEC Alpha 8200, Digital UNIX 3.2.G, and DSA 7.2.2 > > >Mike South > >Producer/Director >"Mike South's Georgia Peaches" >"Mike South's Southern Belles" >"Mike South's Travels" > >Winner 1997 AVN Best Amateur Video >Winner 1996 Rocky Mountain Oyster Readers Poll Best Pro-Am Series > -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care