Re: bcheck -s *.idx produces "Cannot link .idx and .IDX" files

Posted in 1995

Spokey the Wheeler — Sun, 10 Sep 95 14:07:59 GMT — source: Informix-list mailing list archive (1991-1998)

In article <42rb88$g9h@news.wwa.com> john@miso.wwa.com "pinoy_ako" writes: > Hi, > We use SE/R4GL 6.00 on NCR SVR4. One of our programs just suddenly > stopped working with an error saying "Table (tablename) does not > exist". I thought the indices where corrupted so I ran > > bcheck -s *.idx > > in the $DBPATH/[database name].dbs directory. Then it showed me > the error in the subject. Can anyone tell me why the error was > generated? And what do I do with the .IDX files. Pls. email or > post. Thanks! What it *sounds* like is that your system catalogs might be corrupted or that your systables might have an explicit path name which is no longer correct. Have you moved tables around on the disk or ALTERed TABLE or restored backups or anything similar? Check your systables and sysindexes for the table in question. HTH, Spokey the Wheeler------------------------------------------------------------- "Billy Boy" - das aufregende andersche kondom!