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

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! John hasn't posted details of the error. As far as I can remember, the '.IDX' files are copies of the original '.idx' files and are created by using 'bcheck -s'. I prefer to use straight 'bcheck' at least twice - once to apparently fix any problem and a second time to be sure it's fixed! You can restore the original '.idx' files by renameing the '.IDX' ones, or delete them. As to what caused the original corruption - was a process killed or did the machine fall over whilst altering the system catalogues? Did 'bcheck -s' fix the problem? Hope so! But there are ways if the system catalogues are *still* shot. All is not lost yet! Regards -- ============================================================================ Sally Woolrich | This mail contains my personal sally@excelsis.demon.co.uk | views not those of my employer! ============================================================================