SEO

#1 (**permalink**) 04-20-2008, 09:16 AM

hello,

regarding lock mode wait behavior, if i set lock mode wait to 10 - does
informix wait for 10 before re-trying it or does it keep hitting it
repeatedly up to the count of 10 ?

thanks,
tom

#2 (**permalink**) 04-20-2008, 09:16 AM

it doesn't keep retrying it is put on a wait list when the lock is
freed the waiting process is informed that the resource is now
available and it can try and get it.

iso if you have sleep 10 and the lock is available 2 and a half seconds
after you requested it and you are the only process that has requested
it you should acquire the lock after 2 and a half seconds

#3 (**permalink**) 04-20-2008, 09:17 AM

tomcaml@yahoo.com wrote:
> hello,
>
> regarding lock mode wait behavior, if i set lock mode wait to 10 - does
> informix wait for 10 before re-trying it or does it keep hitting it
> repeatedly up to the count of 10 ?
>
>
> thanks,
> tom
>
As scotishpoet wrote, it's not an active waiting, but a passive one...
it sleeps and gets a signal if the lock disappears.

Regards.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

set lock mode to wait