Re: Fail Consistency Check

Naomi Walker writes: |> |> |> Ok, all you bowel level Informix gurus, i'm in need of information. What a flattering term ;-). |> I have a Pyramid MIS-S server, running Online 4.1.UF2. We are getting |> Failed Consistency checks that look like: [deleted] |> I've run tons of tbchecks, which show no problems. This is with one |> exception, |> tbcheck -cc complains of WARNING: no rows found for syscolauth, sysdepend, |> syssyntable, and sysviews, for all databases. Anyone know what that is |>about? Ignore it. that tbcheck option is simply pointing out to you that there are no records in those tables. If you have no column level permissions set, no views defined, and no synonyms defined, then none of those tables should have any records. What you want to run is a tbcheck -cD on the database. The message indicates that there is a page with a messed up header. Dave