Re: isam error: cannot write log record
Hi
We have had similar problems with large updates using dbaccess e.g.
inserting or deleting several thousand rows on a Data General Aviion UG,
but have not experienced the same problem on SCO UNIX to the same
extent. Can you lock a table within dbaccess ?
I thought it must have been that our transaction ...automatically set by
dbaccess was too big and the settings on DG UX were not configured
adequately in some way. Is it just the locks ?
Many thanks
Syd Stewart
4S Information Systems Ltd. England UK.
In article <4phg48$rku@cssun.mathcs.emory.edu>, Apostolos Varnas
<tvarnas@compulink.gr> writes
>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 |
>+---------------------------------------------------------------------+
>
--
Syd Stewart