OnLine V5.06 locking problems

Posted in 1996

Sally Woolrich — Wed, 21 Aug 1996 10:11:44 +0100 — source: Informix-list mailing list archive (1991-1998)

We are having lots of locking problems with an OnLine database. The application (hugh!) works fine with SE and we have use DIRTY READ, LOCK MODE WAIT 20 and ROW level locking to try to make OL behave like SE and minimise the lock problems. This only starts being a problem with 150+ users. There are *plenty* of Informix locks! Any suggestions of nasties in either Informix or in 4GL code which can cause this sort of problem will be most gratefully received! TIA -- Sally Woolrich