Is there a way to tell who has a Record Lock in OI? (OpenInsight 32-Bit)
At 13 NOV 2005 10:36:18AM Dimitri Mandelis wrote:
Is there a way to tell who has a record lock within OI?
We're using the OI711 and the IP NLM Universal Driver.
This would be a handy routine for organizations with multiple people in the same file at the same time. Now our people send mass emails to find out who has it locked and to clear their form.
thanks in advance,
Dimitri
At 13 NOV 2005 02:11PM Bruce Cameron wrote:
From the system monitor window try (or call from a menu or form)
EXEC LIST_USER_LOCKS
and/or
EXEC NLM_STATS
At 13 NOV 2005 05:00PM Dimitri Mandelis wrote:
thanks Bruce,
I did try both of those when I do the List user locks command I get an active locks form but its always empty no matter what I lock or when I press show locks button.
When I run NLM_STATS it comes back with a statement that there aren't any linear hash files attached but I have 100's of files attached.
Does you NLM_STATS or your LIST_USER_LOCKS commands ever show anything on em?
Dimitri
At 14 NOV 2005 02:12PM Jeff Warvel wrote:
I've tried to accomplish the same before (find who has a record locked) without much success from these tools. I could not get LIST_USER_LOCKS to work (OI 7.1.0) as it crash to debugger whenever i pushed the "show locks" button (unassgined var, then i get a FS456 error).
The NLM_STATS does show locks per file, but the interface is lacking. I never could determine where I got our version of NLM_STATS (it doesn't seem to ship with every version of OI.. it probably gets installed during the NLM client side install). I do have a version of $NLM_STATS (compiled 8/21/03) in our SYSOBJ that seems to work.
If you have AREV (2.12 for us) running on the same data, I do have some of our own tools for checking locks.