Re: Problem with altering tables

One instance of when I've encountered this type of error is when a temp table remained in the systables table as a result of an interrupted ALTER TABLE statement in a 5.0x OnLine database (as I recall, my work was being rolled back because my logs weren't large enough). The culprit table names begin with a blank space, so: SELECT * FROM systables WHERE tabname MATCHES " *" If you find any, note the tabid and as user informix: UPDATE systables SET tabname = "lose_me" WHERE tabid = whatever; DROP TABLE lose_me; I'm not sure that this is your problem, but give it a try. ======================================================================= Dennis J. Pimple dennisp@informix.com Opinions expressed Senior Consultant -------------------- are mine, and do not Informix Software Inc Voice: 303-850-0210 necessarily reflect Denver Colorado USA Fax: 303-779-4025 those of my employer. Ron Desjardins (rond@ftp.com) wrote: : Hello, : I am getting the following errors when trying to add a : field to certain tables of my database: : -211 Cannot read system catalog SYSTABLES : and : -111 ISAM error: no record found : The errors occur from both dbaccess (table - alter) and : the alter table command. : I am running Online 5.02 UC6 on a Sun Sparc 20 (SunOS 5.3). : I have called the support line about this. They gave me : several suggestions which did not help. The only one : I have not tried yet has been to unload and drop the : tables which are causing the problems. Export the : database. Import the database and re-create and re-load : the tables. : The support person did say that this had happened to : other Informix users. If this has happened I would greatly : appreciate your solutions. : Just for information, there was no corruption found by any : of the tbchecks. : Thanks : Ron Desjardins : (rond@ftp.com)