<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<meta name=ProgId content=Word.Document>
<meta name=Generator content="Microsoft Word 9">
<meta name=Originator content="Microsoft Word 9">
<link rel=File-List href="cid:filelist.xml@01C5F5C0.AE0B76C0">
<link rel=Edit-Time-Data href="cid:editdata.mso@01C5F5C0.AE0B76C0">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><!--[if gte mso 9]><xml>
<o:OfficeDocumentSettings>
<o:DoNotRelyOnCSS/>
</o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:WordDocument>
<w:Zoom>0</w:Zoom>
<w:DocumentKind>DocumentEmail</w:DocumentKind>
<w:EnvelopeVis/>
</w:WordDocument>
</xml><![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;
mso-font-charset:0;
mso-generic-font-family:swiss;
mso-font-pitch:variable;
mso-font-signature:553679495 -2147483648 8 0 66047 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-parent:"";
margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;
text-underline:single;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;
text-underline:single;}
p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
{margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
p
{margin-right:0in;
mso-margin-top-alt:auto;
mso-margin-bottom-alt:auto;
margin-left:0in;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
span.EmailStyle19
{mso-style-type:personal;
mso-ascii-font-family:Arial;
mso-hansi-font-family:Arial;
mso-bidi-font-family:Arial;
color:black;}
span.EmailStyle20
{mso-style-type:personal;
mso-ascii-font-family:Arial;
mso-hansi-font-family:Arial;
mso-bidi-font-family:Arial;
color:navy;}
span.EmailStyle21
{mso-style-type:personal;
mso-ascii-font-family:Arial;
mso-hansi-font-family:Arial;
mso-bidi-font-family:Arial;
color:navy;}
span.EmailStyle22
{mso-style-type:personal-reply;
mso-ansi-font-size:10.0pt;
mso-ascii-font-family:Arial;
mso-hansi-font-family:Arial;
mso-bidi-font-family:Arial;
color:#993366;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;
mso-header-margin:.5in;
mso-footer-margin:.5in;
mso-paper-source:0;}
div.Section1
{page:Section1;}
/* List Definitions */
@list l0
{mso-list-id:156502317;
mso-list-type:hybrid;
mso-list-template-ids:-548136104 67698703 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l0:level1
{mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l1
{mso-list-id:771242865;
mso-list-type:hybrid;
mso-list-template-ids:-1309375934 -1168225670 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l1:level1
{mso-level-text:%1;
mso-level-tab-stop:.75in;
mso-level-number-position:left;
margin-left:.75in;
text-indent:-.5in;}
@list l2
{mso-list-id:1116873801;
mso-list-type:hybrid;
mso-list-template-ids:1929160270 1337746544 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l2:level1
{mso-level-text:%1;
mso-level-tab-stop:.75in;
mso-level-number-position:left;
margin-left:.75in;
text-indent:-.5in;}
@list l3
{mso-list-id:1131746084;
mso-list-type:hybrid;
mso-list-template-ids:-296059672 -1192976356 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l3:level1
{mso-level-text:%1;
mso-level-tab-stop:53.25pt;
mso-level-number-position:left;
margin-left:53.25pt;
text-indent:-35.25pt;}
@list l4
{mso-list-id:1267882688;
mso-list-type:hybrid;
mso-list-template-ids:1838973834 1008739180 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l4:level1
{mso-level-text:%1;
mso-level-tab-stop:.75in;
mso-level-number-position:left;
margin-left:.75in;
text-indent:-.5in;}
@list l5
{mso-list-id:1403288573;
mso-list-type:hybrid;
mso-list-template-ids:1493615414 1618501926 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l5:level1
{mso-level-text:%1;
mso-level-tab-stop:53.25pt;
mso-level-number-position:left;
margin-left:53.25pt;
text-indent:-35.25pt;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple style='tab-interval:.5in'>
<div class=Section1>
<p class=MsoNormal><span class=EmailStyle22><font size=2 color="#993366"
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'>Hi Joe,<o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle22><font size=2 color="#993366"
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle22><font size=2 color="#993366"
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'>Thanks for your input.<o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle22><font size=2 color="#993366"
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle22><font size=2 color="#993366"
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'>I have tried few suggestions mentioned in the list. Nothing really
worked for me.<o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle22><font size=2 color="#993366"
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle22><font size=2 color="#993366"
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'>Looks like the SQL server database has not been releasing the record
locks on the previous record even after going to the next primary record in the
read chain.<o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle22><font size=2 color="#993366"
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle22><font size=2 color="#993366"
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'>Thanks<o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle22><font size=2 color="#993366"
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'>Sagar<o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle22><font size=2 color="#993366"
face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 color=black
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma;color:black'>-----Original
Message-----<br>
<b><span style='font-weight:bold'>From:</span></b> Joe Boyle
[mailto:atla38@dsl.pipex.com]<br>
<b><span style='font-weight:bold'>Sent:</span></b> Wednesday, November 30, 2005
1:31 PM<br>
<b><span style='font-weight:bold'>To:</span></b> Goparaju, Vidyasagar;
powerh-l@lists.sowder.com<br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: Powerhouse/AIX-
MS-SQL Server locking issues</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'>It’s a big topic, and you
could start by typing the string below at Google’s search page,<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'> <o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'>site:lists.sowder.com
powerh-l autocommit sql server<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'> <o:p></o:p></span></font></p>
<p style='margin-left:.5in'><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'>Regards, Joe.</span></font><font
color=navy><span style='color:navy'> <o:p></o:p></span></font></p>
<div class=MsoNormal align=center style='margin-left:.5in;text-align:center'><font
size=3 color=black face="Times New Roman"><span style='font-size:12.0pt;
color:black'>
<hr size=3 width="100%" align=center>
</span></font></div>
<p class=MsoNormal style='margin-left:.5in'><b><font size=2 color=black
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma;color:black;
font-weight:bold'>From:</span></font></b><font size=2 color=black face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma;color:black'>
powerh-l-bounces+atla38=dsl.pipex.com@lists.sowder.com [mailto:powerh-l-bounces+atla38=dsl.pipex.com@lists.sowder.com]
<b><span style='font-weight:bold'>On Behalf Of </span></b>Goparaju, Vidyasagar<br>
<b><span style='font-weight:bold'>Sent:</span></b> 30 November 2005 19:21<br>
<b><span style='font-weight:bold'>To:</span></b> powerh-l@lists.sowder.com<br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: Powerhouse/AIX-
MS-SQL Server locking issues</span></font><font color=black><span
style='color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=3 color=black
face="Times New Roman"><span style='font-size:12.0pt;color:black'> </span></font><font
color=black><span style='color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:1.0in;text-autospace:none'><font size=2
color=black face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:black'>Hi Listers</span></font><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'>,</span></font><font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:1.0in'><span class=EmailStyle19><font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial'> <o:p></o:p></span></font></span></p>
<p class=MsoNormal style='margin-left:1.0in'><span class=EmailStyle19><font
size=2 color=black face=Arial><span style='font-size:10.0pt;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.<o:p></o:p></span></font></span></p>
<p class=MsoNormal style='margin-left:1.0in'><span class=EmailStyle19><font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial'> <o:p></o:p></span></font></span></p>
<p class=MsoNormal style='margin-left:1.0in'><span class=EmailStyle19><font
size=2 color=black face=Arial><span style='font-size:10.0pt;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. <o:p></o:p></span></font></span></p>
<p class=MsoNormal style='margin-left:1.0in'><font size=2 color=black
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:black'><br>
<span class=EmailStyle19><font color=black>We are having major problem</font></span></span></font><span
class=EmailStyle19><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>s</span></font></span><span
class=EmailStyle19><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial'> with locking and deadlocks in this environment.<o:p></o:p></span></font></span></p>
<p class=MsoNormal style='margin-left:1.0in'><span class=EmailStyle19><font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial'> <o:p></o:p></span></font></span></p>
<p class=MsoNormal style='margin-left:1.0in'><span class=EmailStyle19><font
size=2 color=black face=Arial><span style='font-size:10.0pt;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.<o:p></o:p></span></font></span></p>
<p class=MsoNormal style='margin-left:1.0in'><span class=EmailStyle19><font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial'> <o:p></o:p></span></font></span></p>
<p class=MsoNormal style='margin-left:1.0in'><span class=EmailStyle19><font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial'>Any
suggestions would be greatly appreciated.<o:p></o:p></span></font></span></p>
<p class=MsoNormal style='margin-left:1.0in'><span class=EmailStyle19><font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial'> <o:p></o:p></span></font></span></p>
<p class=MsoNormal style='margin-left:1.0in'><span class=EmailStyle19><font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial'>Thanks<o:p></o:p></span></font></span></p>
<p class=MsoNormal style='margin-left:1.0in'><span class=EmailStyle19><font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial'>Sagar<o:p></o:p></span></font></span></p>
<p class=MsoNormal style='margin-left:1.0in'><span class=EmailStyle19><font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial'>TradePoint
Systems<o:p></o:p></span></font></span></p>
<p class=MsoNormal style='margin-left:1.0in'><span class=EmailStyle19><font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial'> <o:p></o:p></span></font></span></p>
</div>
</body>
<!--[object_id=#tradepointsystems.com#]--><P align=center><FONT face=Tahoma size=1>STATEMENT OF CONFIDENTIALITY:<BR>The information contained in this electronic message is intended for the exclusive use of the addressee(s) and may contain confidential information. If you are not the intended recipient of this email, be advised you have received this message in error and that any use, dissemination, forwarding, printing, or copying is strictly prohibited. Please notify TradePoint Systems LLC immediately at (603) 889-3200 and destroy all copies of this message and any attachments.</FONT></P>
</html>