Re: HELP Informix Locks

Posted in 1996

Sally Woolrich — Thu, 27 Jun 1996 17:09:02 +0100 — source: Informix-list mailing list archive (1991-1998)

In article <835880616.19627.0@xlpt.demon.co.uk>, Vilnis Sube <vilnis@xlpt.demon.co.uk> writes >Does anybody know why Informix-Online 5.0 consumes locks at an >incredible rate when updating a table even though the following >statement has been issued: > > LOCK TABLE test IN SHARE MODE > >The lock type generated as shown by tbstat -k is HDR. > >Thanks in advance >Vil > Try 'LOCK TABLE test IN EXCLUSIVE MODE' instead. -- Sally Woolrich