locking everything

Posted in 1994

Clem W. Akins — 22 Sep 1994 23:03:05 -0400 — source: Informix-list mailing list archive (1991-1998)

In <Cw172q.10C@cix.compulink.co.uk> akent@cix.compulink.co.uk ("Andy Kent") writes: > Just what *is* the reasoning behind the Informix engines testing/locking > everything they touch, not just the rows they bring into the front-end? > > akent@cix.compulink.co.uk (Andy Kent) Is it that you have page locking (not row locking) turned on? That is the default setting. If this is the problem, the fix is to ALTER TABLE tabname LOCK MODE (ROW) from the Informix manual, Guide to SQL, Reference __________________________________________________________________ | Clem Akins Standard Disclaimers Apply | | Reynolds Metals Co. "Climb High, Cave Deep!" | | Muscle Shoals, Alabama USA cwakins@leia.alloys.rmc.com | |________________________________________________________________|