set lock mode to wait
Posted in 2005
Topics: General Discussion
tomcaml@yahoo.com — — source: Usenet: comp.databases.informix
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
↪ replying to tomcaml@yahoo.com
scottishpoet — — source: Usenet: comp.databases.informix
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