Re: Informix SE Errors
Posted in 1998
Topics: Installation, Setup & Upgrades, Error Codes & Troubleshooting, Transactions, Locking & Isolation, Platform-Specific Issues
The problem is that within a transaction, every update you make to a row
produces a Unix Lock on that row, exceeding your Unix parameter FLCKREC (or
equivalent for HP-UX?)
Resolution:
Try a "lock table x in {share|exclusive} mode"
incovenient ?
Re-link your kernel reseting the parameter for locks. No problem with limits
, you can exagerate !
Paulo Abreu
psabreu@usa.net
Rajendra Singh wrote in message <3509820d.2354489@meganews.idirect.com>...
>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