Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Posts
    2

    Unanswered: Help with informix.sys tables please!

    Hello there!

    Really need help on this, we have a historical data server and we had to restore from backup tapes. Problem is the restored (we have a number of Level 0s) DBs are corrupted with lots of BAD pages! We were able to reorg all the tables with BAD pages and recreate some lost indexes except for the following tables:
    -syscolumns
    -sysindexes
    -sysviews
    -sysconstraints

    What would be the purpose of each sys-table and its impact? Thanks

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780

    Re: Help with informix.sys tables please!

    Originally posted by infnovice
    Hello there!

    Really need help on this, we have a historical data server and we had to restore from backup tapes. Problem is the restored (we have a number of Level 0s) DBs are corrupted with lots of BAD pages! We were able to reorg all the tables with BAD pages and recreate some lost indexes except for the following tables:
    -syscolumns
    -sysindexes
    -sysviews
    -sysconstraints

    What would be the purpose of each sys-table and its impact? Thanks
    Hi,

    You run oncheck -cc, oncheck -ce??

    Gustavo.

  3. #3
    Join Date
    Nov 2003
    Posts
    2

    Re: Help with informix.sys tables please!

    Originally posted by gurey
    Hi,

    You run oncheck -cc, oncheck -ce??

    Gustavo.
    Yes, i got the message "WARNING:No syssyntable records found." with oncheck -cc and none from -ce. Anything else I can do?

    Thanks!

  4. #4
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780

    Re: Help with informix.sys tables please!

    Originally posted by infnovice
    Yes, i got the message "WARNING:No syssyntable records found." with oncheck -cc and none from -ce. Anything else I can do?

    Thanks!
    Hi,

    No problem, this is correct.

    Gustavo.

Posting Permissions

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