Problem with SE-5.0 Database after altering Table

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

if you can't write the log record it looks as if there is a problem with the transaction logfile not with any tables in the database itself is the filesystem the transaction log writes to file? Has the file been deleted? snagnews@freenet.de wrote: > 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

finderr on error -121 would support what I said : finderr -121 -121 ISAM error: cannot write log record. The ISAM processor is trying to add a record to the transaction log but has received an error from the operating system. The disk might be full. Look for operating-system error messages that might give more information. The transaction-log file can grow quite large. To reduce its size, you must do two things. First, make a backup copy of the data file (for C-ISAM) or all database files (for SQL). Second, make the transaction-log file an empty file. If you perform these steps routinely, you can control the size of the log file.