var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Alternative to bcheck
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?
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.
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)
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?