[Openroad-users] (no subject)

[Gary Hansford]

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