masters_pj wrote:

> Whenever my app tries to access the file I receive the error:
>
> Checksum error on database page 30472
>
> I have tried using gfix (with and without the -ignore switch) but
> receive a similar error:
>
> -page 30472 is wrong type (expected 5 found 0)
>

What has (probably) happened is that the database shut down before all
pages were written to disk. Since the page was never written, when an
application tries to read that page, it gets a page worth of binary
zeros. The correct value for the checksum is 12345 - we used to
actually checksum pages but it was expensive and it never turned up an
error. 12345 is not zero, so everything shuts down. When gfix ignores
checksum errors, it tries to read the page type from the page header.
It's looking for a data page (type 5) and finds type 0, which is illegal
as well as unexpected.

I'd contact ibsurgeon.com - they're likely to have the tools to fix the
problem.


Regards,


Ann