Re: isam error: cannot write log record
ed wrote:
>
> Greetings:
>
> Using SCO Unix
> and Informix Standard Engine version 5.01.UD2.
>
> When doing a rather large update within ISQL/Dbaccess such as
>
> update tcf set tcf.acc_week_reg = 0 where tcf.pay_code = "HR">
> we get the following error
>
> 346: Could not update a row in the table
> 121: ISAM error: cannot write log record.>
> Move to the on-line engine and the error goes away.
>
> Has anyone seen this one before? Any help would be appreciated.
>
> ed
> schaefer
> Remember... No matter where you go, there you are !
Ed,
if you have enough space on the device where your logfile resides you are
running out of locks.Either increase the number of locks for SCO or lock the
table you want to update, this will save you the locks for every record
updated:
begin work;
lock table tcf in exclusive mode;
update tcf ...;
If everything is ok then issue
commit work;
else
rollback work;
Note: You can only issue the lock table statement within a transaction in a
db with transactions.The commit work or rollback work statement releases the
table lock automatically so you don't need an unlock table statement.
Regards
Tolis
+---------------------------------------------------------------------+
| V+K Relational Solutions email: tvarnas@compulink.gr |
| Deligiorgi 26 tvarnas@orbit.de |
| 546 42 Thessaloniki Voice: (30) 31 820270 |
| Greece Fax: (30) 31 865463 |
+---------------------------------------------------------------------+