<html><div style='background-color:'><P><FONT style="FONT-SIZE: 11px; FONT-FAMILY: tahoma,sans-serif"><EM></EM> Hi <SPAN class=EmailStyle16><FONT face=Arial color=black size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Sagar:</SPAN></FONT></SPAN></FONT></P>
<P><FONT style="FONT-SIZE: 11px; FONT-FAMILY: tahoma,sans-serif"><SPAN class=EmailStyle16><FONT face=Arial color=black size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> 1) SQL Server needs to have its log truncated frequently. </SPAN></FONT></SPAN></FONT></P>
<P><FONT style="FONT-SIZE: 11px; FONT-FAMILY: tahoma,sans-serif"><SPAN class=EmailStyle16><FONT face=Arial color=black size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> When it is full SQL Server waits for some process to truncate it.</SPAN></FONT></SPAN></FONT></P>
<P><FONT style="FONT-SIZE: 11px; FONT-FAMILY: tahoma,sans-serif"><SPAN class=EmailStyle16><FONT face=Arial color=black size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> So what looks like a lock wait situation may in fact be a log wait</SPAN></FONT></SPAN></FONT></P>
<P><FONT style="FONT-SIZE: 11px; FONT-FAMILY: tahoma,sans-serif"><SPAN class=EmailStyle16><FONT face=Arial color=black size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> situation.</SPAN></FONT></SPAN></FONT><FONT style="FONT-SIZE: 11px; FONT-FAMILY: tahoma,sans-serif"></P>
<P> 2) Try to the place puts to the tables in the same order in each </P>
<P> screen of a group of related QUICK screens.</P>
<P> 3) Use AUTOCOMMIT on your lookups.</P>
<P> Good luck,</P>
<P> Peter</P>
<P> </P>
<P> </P>
<P> </P>
<P> </P>
<META content="Microsoft SafeHTML" name=Generator>
<STYLE>
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:'Times New Roman';}
p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:'Times New Roman';}
span.EmailStyle16
{color:black;}
span.EmailStyle17
{color:navy;}
@page Section1
{size:8.5in 11.0in;margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
</STYLE>
<BLOCKQUOTE style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #a0c6e5 2px solid; MARGIN-RIGHT: 0px">
<DIV class=Section1>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Arial color=black size=2><SPAN style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial">Hi <BR>Listers</SPAN></FONT><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">,</SPAN></FONT><FONT face=Arial color=black size=2><SPAN style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial"></SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><SPAN class=EmailStyle16><FONT face=Arial color=black size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></SPAN></FONT></SPAN> </P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><SPAN class=EmailStyle16><FONT face=Arial color=black size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">We have successfully migrated our application from VMS/RMS environment to AIX/Oracle. Except some performance issues in some areas we look good there.</SPAN></FONT></SPAN></P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><SPAN class=EmailStyle16><FONT face=Arial color=black size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></SPAN></FONT></SPAN> </P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><SPAN class=EmailStyle16><FONT face=Arial color=black size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Now we are on to AIX/MS-SQL Server environment under the same version of Powerhouse PH.8.43.D1 and running the same code with minor changes to fix some compilation errors. </SPAN></FONT></SPAN></P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Arial color=black size=2><SPAN style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial"><BR><SPAN class=EmailStyle16><FONT color=black>We are having major problem</FONT></SPAN></SPAN></FONT><SPAN class=EmailStyle16><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">s</SPAN></FONT></SPAN><SPAN class=EmailStyle16><FONT face=Arial color=black size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> with locking and deadlocks in this environment.</SPAN></FONT></SPAN></P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><SPAN class=EmailStyle16><FONT face=Arial color=black size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></SPAN></FONT></SPAN> </P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><SPAN class=EmailStyle16><FONT face=Arial color=black size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">I have experimented with some transactions within Quick, but nothing really works. Not sure whether we need any changes on the ODBC connection, database end or Powerhouse.</SPAN></FONT></SPAN></P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><SPAN class=EmailStyle16><FONT face=Arial color=black size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></SPAN></FONT></SPAN> </P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><SPAN class=EmailStyle16><FONT face=Arial color=black size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Any suggestions would be greatly appreciated.</SPAN></FONT></SPAN></P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><SPAN class=EmailStyle16><FONT face=Arial color=black size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></SPAN></FONT></SPAN> </P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><SPAN class=EmailStyle16><FONT face=Arial color=black size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Thanks</SPAN></FONT></SPAN></P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><SPAN class=EmailStyle16><FONT face=Arial color=black size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Sagar</SPAN></FONT></SPAN></P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><SPAN class=EmailStyle16><FONT face=Arial color=black size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">TradePoint Systems</SPAN></FONT></SPAN></P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><SPAN class=EmailStyle16><FONT face=Arial color=black size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></SPAN></FONT></SPAN> </P></DIV>
<P align=center><BR> </P>
<P></FONT></P></BLOCKQUOTE></div><br clear=all><hr>Free yourself from those irritating pop-up ads with <a href="http://g.msn.com/8HMAENCA/2734??PS=47575" target="_top">MSN Premium: </a> Join now and get the first two months FREE*</html>