[Openroad-users] (no subject)

[Larry West]

At the time of the hang, ipm shows a lock "LOCK(P" in the query 
execution facility "Execute mcompsrc3"

At 08:11 AM 2/15/2008, you wrote:
>Larry,
>
>  If its only happening on the remote vnodes (and not the local database)
>then you really need to investigate what happens when you click on
>delete/save etc. You'll have to use ipm on the remote server, to see the
>status of your DBMS session and what it is waiting for. You could also
>start to diagnose the issue from the OR2006 client using
>
>    ingsetenv II_EMBED_SET "printqry;qryfile c:\temp\iiprtqry.log"
>
>Have a look at the c:\temp\iiprtqry.log file when the hang occurs to see
>what (if anything) it has sent to the server etc..
>
>You could also inject the display of the SQL thats being fired using
>
>    ingsetenv ING_PRINT "set printqry"
>
>You'll then see in the OpenRoad trace window all the SQL being fired..
>if any :-)...
>
>This may give you some more pointers...
>
>Gary
>
>
>
>E-Mail Notice and disclaimer.
>
>This e-mail (including any attachment) is intended for the addressee 
>named above. As this e-mail may contain confidential or privileged 
>information, if you are not the named addressee, or the person 
>responsible for delivering the message to the named addressee, 
>please notify us immediately.
>Every effort has been made to ensure that this e mail and any 
>attachment is free from viruses but we give no warranty to that 
>effect and can accept no responsibility for any losses resulting 
>from infected e-mail. The internet cannot guarantee the integrity of 
>this message. Indesit Company UK Ltd (and its subsidiaries) shall 
>not be liable for the message if modified. Please note that any 
>views expressed in this e-mail may be those of the author and do not 
>necessarily reflect those of this organisation.
>Indesit Company UK Limited
>Registered Office: Morley Way, Peterborough, PE2 9JB.
>Company Number 106725. EEE Reg. Number WEE/DH0057TS
>
>________________________________________________________________
>OpenROAD-Users mailing list
>
>You can maintain your subscription here:
>http://www.peerlessit.com/mailman/listinfo/openroad-users
>
>To unsubscribe click on this link
>mailto:openroad-users-unsubscribe at peerlessit.com&subject=unsubscribe
>
>To subscribe click on this link
>mailto:openroad-users-subscribe at peerlessit.com&subject=subscribe


Larry West
Applied Physics Lab, University of Washington<br>
(206) 543-1644<