Re: SET LOCK MODE TO WAIT ?

Jon C. Vemo (jvemo@cyberspace.com) wrote: : At 11:51 AM 7/14/95 MDT, Jack Parker wrote: : > : >My 4gl 4.0 manual on page 7-223 documents SET LOCK MODE TO [NOT] WAIT. It : >gives no indication of a time you can set it to. I would imagine that this : >is an engine level command and not restricted to the front end tool. I : >would also imagine that the default amount of time to wait would be that : >which was set up for the engine when it was initialized under : >'Deadlock Timeout' under the Shared Memory parameters. : In the 7.1 Informix guide to SQL: Syntax, page 1-467, it specifies that SET : LOCK MODE TO WAIT <seconds> is available, however only for OnLine. I do not : have the older doc's, but I seem to recall this same functionality available : in 5.x (again Online only). : The DEADLOCK_TIMEOUT parameter, according to the TFM, appears to only apply : to networked environments (which I assume implies distributed type access, : and not, say, local loopback under DSA). In this environment the SET LOCK : MODE WAIT <seconds> is only valid if set to less then the DEADLOCK_TIMEOUT : setting. SET LOCK MODE TO WAIT x {seconds} has existed in all the versions of OnLine (don't know about Turbo -- I'm too young ;) The reason it's not in the 4.0 4GL manual is that, back in those days, the 4GL and SQL manuals only documented features that were available in SE -- anything that was specific to OnLine was only in the OnLine manual. If you look in the 4.0 OnLine manual, it's probably in there. (Jim, your memory is not playing tricks on you :) Jon's right -- DEADLOCK_TIMEOUT is only for networked environments. It sets a timeout limit on distributed transactions because we cannot do deadlock detection for remote lock requests the way we do for locking on a single instance. June ---- June Tong Informix Software ---- ---- junet@informix.com (415) 926-6140 ----