SEO

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.