Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Brian Green — — source: Informix-list mailing list archive (1991-1998)
KX> All ... we are having a bit of a time with the adjacent row delete
...
KX> -245 Could not position within a file via an index.
KX> -144 ISAM error: key value locked.
KX> We are now seeing the problem with NON-adjacent rows. I am assuming we
If you are using page level locking, that may be the culprit. Another
possibility is that you may need to update statistics. We had a similar
problem where a table with row level locking would suddenly begin locking
on a page level. The problem went away if we did an update statistics.
Eventually, we added it to cron.
---
~ SPEED 1.40 [NR] ~
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.