Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2002
    Posts
    2

    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

  2. #2
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    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?
    rws

  3. #3
    Join Date
    Aug 2002
    Posts
    2
    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

  4. #4
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    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?
    rws

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •