Re: System Catalog tables

Richard Hassler wrote: > > I'm running Informix ONLINE 5.0 on an HP-UX 9.0 9000/832 > > I have two databases defined (student and gradsch) with multiple > tables in each that have been in use for two years or more. > > When I do: > tbcheck -cI -cD -q student > I get: > WARNING: No syscolauth records found. > ISAM error: no record found.> ERROR: No table found for syssynonyms record. > Tabid 192 > Server name > Database Name gradsch > Owner informix > Table name studname > Tabid of base table -2147483648 > > When I do: > tbcheck -cI -cD -q gradsch > I get: > WARNING:No syscolauth records found. > WARNING:No sysdepend records found. > WARNING:No syssyntable records found. > WARNING:No sysviews records found. > > These messages have been happening for some time, probably > since I started running these tbcheck commands. Everything > seems to work ok I just think there ought to be a way to > get rid of these obnoxious messages. > <snip> > and no problems. Reading the manual 'INFORMIX Guide to SQL > Reference version 4.10 it talks about these tables but as > near as I can determine, it doesn't say how the data gets > into them. These tables have data entered whenever you execute commands such as CREATE VIEW, GRANT, etc. It's how the system holds the information which defines the view or whatever. They're created when the database is created. It looks like someone has DROPped the relevant tables. I suggest you unload the data, drop and recreate the databases and reload. In the circumstances I don't know if DBSCHEMA will run or not. If it does you can use it to get the table definitions, otherwise you'll have to type it in from documentation, use TABLE->INFO or whatever to pick up the structure. It there were views or synonyms declared you've lost those with the system catalogue tables. For those you'll have to depend on documentation or memory. When you've rebuilt it all, keep a close control on DBA privilege! Regards Ian