Re: set lock mode to wait

Posted in 2003

rkusenet — Fri, 9 May 2003 18:23:48 -0400 — source: Usenet: comp.databases.informix

"tomL" <schmotom@yahoo.com> wrote > from another post: > Just SET LOCK MODE TO WAIT 10; then the client session will wait for > 10 seconds for any transient locks to clear before returning a lock > error. > Unless your apps are poorly designed most locks are transient so this > is > the correct solution. > > Art S. Kagel > > ++++++++++++++++ > my question is: > does Informix WAIT for this amount of time before trying again No. > or does it keep trying continually during the waiting period for the specified length of time? yes. The 10 seconds is maximum time to wait by the client before returing the error. For all transient locks, the actual wait time is much less.