Does anyone know and alternative to bcheck to check the validity of the database??

I have changed the hardware on the machine several times and have also changed unix on it putting all the new patches but system tables still go corrupt.

any ideas any one??

Thanks in advance

Are you using C-Isam or SE?
What version?
These are very simple databases. I don't think there 's an alternative.

I thought C-Isam used bcheck only to check the index structures.

Did you try to unload/load the table?

Using informix 5 SE
have unloaded dropped, recreated and reloaded the data but then corruption moves on to different tanbles then eventually to a system table.

ohh well

5 is very old!
We are now at 7.25 for SE.
Is your database big? Could you try to unload the whole database and reload it? You can use a script to do that:

UNLOAD TO dbunload.sql DELIMITER ';'
SELECT "UNLOAD to " || trim(tabname) || ".sql SELECT * FROM " || trim(tabname)
FROM SYSTABLES
WHERE tabid > 99
AND tabtype = 'T'

Create a new database and reload it.

Do you get error messages? Which ones?
Which system table gets corrupted?
Is it maybe a disk problem?