Re: HELP Informix Locks

Posted in 1996

Apostolos Varnas — 27 Jun 1996 12:48:22 -0400 — source: Informix-list mailing list archive (1991-1998)

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 Hi Vil, it has to do with the lock mode of your table.If it is page mode it will only place 1 lock on the table.If it is row mode it will place a lock on every row even if you issued a lock table .. in share mode before. If you however issue a lock table in exclusive mode it will place only 1 lock regardless of the lock mode of the table.I am not sure if this is a feature or a bug. Regards Tolis +---------------------------------------------------------------------+ | V+K Relational Solutions email: tvarnas@compulink.gr | | Deligiorgi 26 tvarnas@orbit.de | | 546 42 Thessaloniki Voice: (30) 31 820270 | | Greece Fax: (30) 31 865463 | +---------------------------------------------------------------------+