Index Read Errors

Posted in 1996

DRI — Mon, 16 Dec 1996 11:01:47 -0500 — source: Informix-list mailing list archive (1991-1998)

We're using stored procedures to update a set of tables on a data server which are maintained by an invoice payment app used concurrently by 100 or so users. The application sets isolation to DIRTY READ for each session, yet during periods of heavy usage, stored procs are failing due to index read errors. Row locking is used on all tables and a row is locked while a user is modifying an invoice that is in the tables. Looking for suggestions as to how we can eliminate this problem.