[email protected] wrote: > Hello > i need the name of the table that keeps item locks. when i do a SHOW- > ITEM-LOCKS it takes forever, but i am thinking if i can get the table > then i'll do a select query to select a particular record, hopefully > that'll be faster. > There is no spoon (points for knowing the reference).
Why it takes so long is: 1) You should not need to run this command very often; 2) It asks all the processes to to dump their lock information in the proc directory (simplistically speaking) , then iterates it, so it is waiting for processes to respond to the requests; 3) Greg is a fat bloke with no mates, though he is going down the Gym now; 4) See 1) 5) Er.... 6) That's it.. Seriously though, your question implies that you are trying to use this command a lot and you really should not be. SHOW-ITEM-LOCKS is debugging tool really and though for 20 years I have been telling people not to write background processes to 'monitor' things, it seems to be every programmers dream to do so. First, ask yourself why the response time of this command matters to you; if you have processes locking up, then you almost certainly have an application problem that you need to debug. The problem with this sort of diagnostic is that it engenders the idea that the fix for a problem that needs it is the kill command :-( SHOW-ITEM-LOCKS asks all the processes on the system for information that cannot be gleaned directly from the lock table, hence it waits to gather the information. Perhaps LIST-ITEM-LOCKS will be quicker for you, but definitely ask yourself why the response time of this command is important! Jim --~--~---------~--~----~------------~-------~--~----~ Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24 To post, send email to [email protected] To unsubscribe, send email to [email protected] For more options, visit this group at http://groups.google.com/group/jBASE?hl=en -~----------~----~----~----~------~----~------~--~---
