Re: [Info-ingres] Corrupt ii_encodings catalog

At 12:59 PM +0000 1/17/06, Gibson Jonathan wrote: 
Hi All,

We've got a problem here with BAD_FILE_PAGE_ADDR on the ii_encodings catalog. Since this holds encoded 4GL frames and procedures, is it possible to rebuild it without having to do a rollforward (this hasn't been spotted for a while so we'd have to go back to an old backup to get a successful rollforward). 

Yes, in principle.  It's been too long since I messed with the ABF
catalogs.  You might want to experiment with a junk database to see
if you can just toss ii_encodings or if you have to mess with any of
the other abf catalogs too, like ii_abfdependencies.



We've also got another database on this server, which is incidentally a test server, where they've been getting the same error on both iiattribute and iiqrytext.... Is it possible to rebuild these catalogs without a rollforward? 

generally, no.  I suppose you can't run a sysmod?

Karl
.

Relevant Pages

  • Re: Update to SP4 causes starnge Server behavior
    ... IIRC Service Pack 4 involves a ... rebuilding of your full-text catalogs. ... All full-text catalogs are rebuilt as part of the installation of SP4 when ... results or no results until the rebuild process is complete. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Cant get AND to work.
    ... empty the noise.enu or noiseenu.txt files and replace them with a ... single space. ... Then rebuild your catalogs. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: SP4 and FT - can not find some words. Help...
    ... I have deleted and created FT catalogs. ... trackimg, background updating. ... >>> On the SQLServer SP3 my stored procedure worked fine. ... >>> I have install SP4 and rebuild FT catalogs. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Full-Text Catalogs
    ... > If you restore the file to its original path, I think you don't even have ... > to rebuild the catalog. ... >> Books online states that only Meta Data of Full-Text Catalogs are backed ...
    (microsoft.public.cert.mcdba)