Re: Problem with SE-5.0 Database after altering Table

You may be hit some limit? (Just guessing...) Tryed IBM support? J. snagnews@freenet.de escribis: > Hello, > > we using Informix SE 5.0 with Informix 4GL 4.20 on Tru64 4.0F to 5.1B - > Compaq Alpha-Workstations. > > Now we have altered a table in all databases with appr. 123000 rows (on > 110 SE-databases on 5 Unix-Boxes). We have added a new character-field > with 2 chars and now we get several errors from the databaseserver, if > we would access this table for reading or updating rows in this table. > > In most cases, we become following Error : > > SQL statement error number -271. > Could not insert new row into the table. > SYSTEM error number -121. > ISAM error: cannot write log record> > followed by errors that shows, that a record cannot be inserted, > updated, deleted and so on. (SQL-Errors -271, -311, -240, ..., > ISAM-Errors -77, -113, -121, -111 (The ISAM-Errors seems to be > OS-Dependend but we have nothing changed on the boxes and the Errors > appears on several machines and several databases) > > All 4gl-Programs are new compiled with the new structure of the table. > > We have bchecked the table, dbexported and imported the whole database, > unloaded and loaded the table. > > The database is correctly started and the log can be written from the > database-server. > > Any hints? > Thks in advance. > > Greetings > Andy sending to informix-list