[Openroad-users] (no subject)

[Brigitte Duplenne]

Hi Larry,

Do you mind opening an issue with our Ingres support and attach the
printqry.log. 
Please let me know the issue number when it is done.

Thank you,
Brigitte

OpenROAD support.


-----Original Message-----
From: openroad-users-bounces at peerlessit.com
[mailto:openroad-users-bounces at peerlessit.com] On Behalf Of Larry West
Sent: vendredi 15 février 2008 10:04
To: International OpenROAD Users
Subject: Re: [Openroad-users] (no subject)

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<

________________________________________________________________
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