Re: SET LOCK MODE TO WAIT ?

At 11:51 AM 7/14/95 MDT, Jack Parker wrote: >> >> >> In a recent mail exchange with another Informix programmer, he mentioned >> that it was possible to use "SET LOCK MODE TO WAIT 60" and have the >> system time out after the table was unavailable for 60 seconds. I've >> been digging through the documentation and can find nothing to support >> his claim. If true it would be a godsend for handling potential >> permanent lockups. >> >> Can anyone confirm or deny that a wait period can be specified as a >> parameter to SET LOCK MODE TO WAIT and if so, what is the default? >> > >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. Jon ================================================================== Jon Vemo Internet: jvemo@cyberspace.com Bothell, WA USA ------------------------------------------------------------------ Watch out for road-kill on the information superhighway....SPLAT!! ==================================================================