SEO

Have you tried running a bcheck / oncheck on the table ?


-----Original Message-----
From: owner-informix-list@iiug.org [mailtowner-informix-list@iiug.org]
On Behalf Of snagnews@freenet.de
Sent: 30 August 2005 10:24 AM
To: informix-list@iiug.org
Subject: 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
sending to informix-list