Help with informix.sys tables please!

infnovice · #1 (**permalink**) 11-11-03, 02:56

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

gurey · #2 (**permalink**) 11-11-03, 09:09

Quote:

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.

infnovice · #3 (**permalink**) 11-11-03, 18:34

Quote:

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!

gurey · #4 (**permalink**) 11-12-03, 08:24

Quote:

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.

Internet Services

Web Development

Digital Marketing

Consumer Tech