Re: HELP Informix Locks

Posted in 1996

Cheryl Kendricks — 27 Jun 1996 12:33:24 -0400 — source: Informix-list mailing list archive (1991-1998)

The number of LOCK's depends on many things, here are three just to name a few: 1. Level of LOCK (Page or ROW) for table 2. How many Pages or ROWs you are updating 3. Does this update also include Indexed columns (Locks for the Index) If you would like further information from me please E-mail me directly on this subject. ------------------------------------------------------------------------- Cheryl Kendricks Internet:cherylk@prod1.jcdc.doleta.gov OR cherylk@gwysmtp.jcdc.doleta.gov DTSI, Inc. Database Administrator - DOL Job Corps San Marcos, Texas ------------------------------------------------------------------------ On Thu, 27 Jun 1996, Vilnis Sube wrote: > 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 > >