Re: Informix SE Errors

In article <3509820d.2354489@meganews.idirect.com>, Rajendra Singh <rajsingh@hotmail.com> writes >We've recently installed Informix SE 7.2 on HP-UX 10.20. We're getting the >following errors when we try to update a single column in a single (large) >table: >346: Could not update a row in the table.> >121: ISAM error: cannot write log record> >I've looked up these error codes in the manual, but they are of little help. >Can anyone else shed some light as to why these errors are occuring. > >We have another installation of Informix 6.0 running on HP-UX 9.04 using the >exact same table(s) and that error does not occur. >-- >Mr. Rajendra Singh, B. Sc. (rajsingh@hotmail.com) >"What is understood need not be discussed." - Loren Adams Run the following query select dirpath from systables where tabtype = "L" This will tell you where you transaction logfile is. For some reason Informix cannot write to it. Also try locking the table in exclusive mode as it may be that UNIX is running out of locks. -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care