<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@01C5F71D.72F52D70">
<link rel=Edit-Time-Data href="cid:editdata.mso@01C5F71D.72F52D70">
<!--[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:blue;
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.emailstyle16
{mso-style-name:emailstyle16;
color:black;}
span.emailstyle17
{mso-style-name:emailstyle17;
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:navy;}
@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;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=blue style='tab-interval:.5in'>
<div class=Section1>
<p class=MsoNormal><span class=EmailStyle22><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>Hi Peter,<o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle22><font size=2 color=navy 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='mso-layout-grid-align:none;text-autospace:none'><font
size=2 color=navy face="Courier New"><span style='font-size:10.0pt;font-family:
"Courier New";color:navy'>Here is the example that I have been working on. </span></font><font
size=2 color=navy face="Courier New"><span style='font-size:10.0pt;font-family:
"Courier New";color:navy;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><font
size=2 color=navy face="Courier New"><span style='font-size:10.0pt;font-family:
"Courier New";color:navy'><![if !supportEmptyParas]> <![endif]></span></font><font
size=2 color=navy face="Courier New"><span style='font-size:10.0pt;font-family:
"Courier New";color:navy;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><font
size=2 color=navy face="Courier New"><span style='font-size:10.0pt;font-family:
"Courier New";color:navy'>I was able to get thru the 'DEADLOCK' issue with the
following transaction model. I have tried various models. But the following
does not result in DEADLOCK. But is not complete as per my requirement.</span></font><font
size=2 color=navy face="Courier New"><span style='font-size:10.0pt;font-family:
"Courier New";color:navy;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><font
size=2 color=navy face="Courier New"><span style='font-size:10.0pt;font-family:
"Courier New";color:navy'><![if !supportEmptyParas]> <![endif]></span></font><font
size=2 color=navy face="Courier New"><span style='font-size:10.0pt;font-family:
"Courier New";color:navy;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><font
size=2 color=red face="Courier New"><span style='font-size:10.0pt;font-family:
"Courier New";color:red'>screen test transaction model dual<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><font
size=2 color=red face="Courier New"><span style='font-size:10.0pt;font-family:
"Courier New";color:red'>transaction myupdate READ WRITE <o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><font
size=2 color=red face="Courier New"><span style='font-size:10.0pt;font-family:
"Courier New";color:red'>file shipment_dates in tpsdb designer transaction
myupdate<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><font
size=2 color=red face="Courier New"><span style='font-size:10.0pt;font-family:
"Courier New";color:red'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><font
size=2 color=red face="Courier New"><span style='font-size:10.0pt;font-family:
"Courier New";color:red'>procedure initialize<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><font
size=2 color=red face="Courier New"><span style='font-size:10.0pt;font-family:
"Courier New";color:red'>begin<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><font
size=2 color=red face="Courier New"><span style='font-size:10.0pt;font-family:
"Courier New";color:red'><span style="mso-spacerun: yes">
</span>start transaction myupdate<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><font
size=2 color=red face="Courier New"><span style='font-size:10.0pt;font-family:
"Courier New";color:red'><span style="mso-spacerun: yes">
</span>get shipment_dates via file_no,tracing_Date_no using 1,1<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><font
size=2 color=red face="Courier New"><span style='font-size:10.0pt;font-family:
"Courier New";color:red'><span style="mso-spacerun: yes"> </span>if
accessok<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><font
size=2 color=red face="Courier New"><span style='font-size:10.0pt;font-family:
"Courier New";color:red'><span style="mso-spacerun: yes">
</span>then begin<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><font
size=2 color=red face="Courier New"><span style='font-size:10.0pt;font-family:
"Courier New";color:red'><span style="mso-spacerun:
yes"> </span>info
message=ascii(file_no) + "<span style="mso-spacerun: yes">
</span>" + ascii(time_updated) now resp<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><font
size=2 color=red face="Courier New"><span style='font-size:10.0pt;font-family:
"Courier New";color:red'><span style="mso-spacerun:
yes"> </span>let
time_updated = time_updated + 1<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><font
size=2 color=red face="Courier New"><span style='font-size:10.0pt;font-family:
"Courier New";color:red'><span style="mso-spacerun:
yes"> </span>put
shipment_dates<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><font
size=2 color=red face="Courier New"><span style='font-size:10.0pt;font-family:
"Courier New";color:red'><span style="mso-spacerun:
yes"> </span>commit<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><font
size=2 color=red face="Courier New"><span style='font-size:10.0pt;font-family:
"Courier New";color:red'><span style="mso-spacerun:
yes"> </span>end<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><font
size=2 color=red face="Courier New"><span style='font-size:10.0pt;font-family:
"Courier New";color:red'>end<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><font
size=2 color=red face="Courier New"><span style='font-size:10.0pt;font-family:
"Courier New";color:red'>build <o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><font
size=2 color=navy face="Courier New"><span style='font-size:10.0pt;font-family:
"Courier New";color:navy'><![if !supportEmptyParas]> <![endif]></span></font><font
size=2 color=navy face="Courier New"><span style='font-size:10.0pt;font-family:
"Courier New";color:navy;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><font
size=2 color=navy face="Courier New"><span style='font-size:10.0pt;font-family:
"Courier New";color:navy'>My requirement is when I run the same screen from two
different sessions</span></font><font size=2 color=navy face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New";color:navy;mso-color-alt:
windowtext'><o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><font
size=2 color=navy face="Courier New"><span style='font-size:10.0pt;font-family:
"Courier New";color:navy'>simultaneously, second session should wait on the GET
as it should be locked</span></font><font size=2 color=navy face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New";color:navy;mso-color-alt:
windowtext'><o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><font
size=2 color=navy face="Courier New"><span style='font-size:10.0pt;font-family:
"Courier New";color:navy'>by the first one. First one should release the record
after the commit and</span></font><font size=2 color=navy face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New";color:navy;mso-color-alt:
windowtext'><o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><font
size=2 color=navy face="Courier New"><span style='font-size:10.0pt;font-family:
"Courier New";color:navy'>then second one grabs the record and increments the
counter. We have this</span></font><font size=2 color=navy face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New";color:navy;mso-color-alt:
windowtext'><o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><font
size=2 color=navy face="Courier New"><span style='font-size:10.0pt;font-family:
"Courier New";color:navy'>type of processing everywhere in the application and
LOCK before read and</span></font><font size=2 color=navy face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New";color:navy;mso-color-alt:
windowtext'><o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><font
size=2 color=navy face="Courier New"><span style='font-size:10.0pt;font-family:
"Courier New";color:navy'>Unlock/COMMIT after PUT was the only way to do it. As
we don't have these</span></font><font size=2 color=navy face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New";color:navy;mso-color-alt:
windowtext'><o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><font
size=2 color=navy face="Courier New"><span style='font-size:10.0pt;font-family:
"Courier New";color:navy'>options on SQL Server it is a real pain.</span></font><font
size=2 color=navy face="Courier New"><span style='font-size:10.0pt;font-family:
"Courier New";color:navy;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p class=MsoNormal><span class=EmailStyle22><font size=2 color=navy 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=navy 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=navy face=Arial><span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>Thanks for
all the input and suggestions.<o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle22><font size=2 color=navy 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=navy 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=navy face=Arial><span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>TradePoint
Systems <o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle22><font size=2 color=navy 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> powerh-l-bounces+vgoparaju=tradepointsystems.com@lists.sowder.com
[mailto:powerh-l-bounces+vgoparaju=tradepointsystems.com@lists.sowder.com]<b><span
style='font-weight:bold'>On Behalf Of </span></b>Peter Bateman<br>
<b><span style='font-weight:bold'>Sent:</span></b> Thursday, December 01, 2005
8:14 PM<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></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 style='margin-left:.5in'><font size=1 color=black face=Tahoma><span
style='font-size:8.5pt;font-family:Tahoma;color:black'>
Hi </span></font><span class=emailstyle16><font size=2 color=black face=Arial><span
style='font-size:10.0pt;font-family:Arial'>Sagar:</span></font></span><font
color=black><span style='color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p style='margin-left:.5in'><span class=emailstyle16><font size=2 color=black
face=Arial><span style='font-size:10.0pt;font-family:Arial'> 1)
SQL Server needs to have its log truncated frequently. </span></font></span><font
color=black><span style='color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p style='margin-left:.5in'><span class=emailstyle16><font size=2 color=black
face=Arial><span style='font-size:10.0pt;font-family:Arial'>
When it is full SQL Server waits for some process to truncate it.</span></font></span><font
color=black><span style='color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p style='margin-left:.5in'><span class=emailstyle16><font size=2 color=black
face=Arial><span style='font-size:10.0pt;font-family:Arial'>
So what looks like a lock wait situation may in fact be a log wait</span></font></span><font
color=black><span style='color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p style='margin-left:.5in'><span class=emailstyle16><font size=2 color=black
face=Arial><span style='font-size:10.0pt;font-family:Arial'>
situation.</span></font></span><font size=1 color=black face=Tahoma><span
style='font-size:8.5pt;font-family:Tahoma;color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p style='margin-left:.5in'><font size=1 color=black face=Tahoma><span
style='font-size:8.5pt;font-family:Tahoma;color:black'> 2) Try
to the place puts to the tables in the same order in each </span></font><font
size=1 color=black face=Tahoma><span style='font-size:8.5pt;font-family:Tahoma;
color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p style='margin-left:.5in'><font size=1 color=black face=Tahoma><span
style='font-size:8.5pt;font-family:Tahoma;color:black'> screen of
a group of related QUICK screens.</span></font><font size=1
color=black face=Tahoma><span style='font-size:8.5pt;font-family:Tahoma;
color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p style='margin-left:.5in'><font size=1 color=black face=Tahoma><span
style='font-size:8.5pt;font-family:Tahoma;color:black'> 3)
Use AUTOCOMMIT on your lookups.</span></font><font size=1 color=black
face=Tahoma><span style='font-size:8.5pt;font-family:Tahoma;color:black;
mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p style='margin-left:.5in'><font size=1 color=black face=Tahoma><span
style='font-size:8.5pt;font-family:Tahoma;color:black'> Good
luck,</span></font><font size=1 color=black face=Tahoma><span style='font-size:
8.5pt;font-family:Tahoma;color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p style='margin-left:.5in'><font size=1 color=black face=Tahoma><span
style='font-size:8.5pt;font-family:Tahoma;color:black'>
Peter</span></font><font size=1 color=black face=Tahoma><span style='font-size:
8.5pt;font-family:Tahoma;color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p style='margin-left:.5in'><font size=1 color=black face=Tahoma><span
style='font-size:8.5pt;font-family:Tahoma;color:black'> </span></font><font
size=1 color=black face=Tahoma><span style='font-size:8.5pt;font-family:Tahoma;
color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p style='margin-left:.5in'><font size=1 color=black face=Tahoma><span
style='font-size:8.5pt;font-family:Tahoma;color:black'> </span></font><font
size=1 color=black face=Tahoma><span style='font-size:8.5pt;font-family:Tahoma;
color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p style='margin-left:.5in'><font size=1 color=black face=Tahoma><span
style='font-size:8.5pt;font-family:Tahoma;color:black'> </span></font><font
size=1 color=black face=Tahoma><span style='font-size:8.5pt;font-family:Tahoma;
color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p style='margin-left:.5in'><font size=1 color=black face=Tahoma><span
style='font-size:8.5pt;font-family:Tahoma;color:black'> </span></font><font
size=1 color=black face=Tahoma><span style='font-size:8.5pt;font-family:Tahoma;
color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<div style='border:none;border-left:solid #A0C6E5 1.5pt;padding:0in 0in 0in 4.0pt'>
<p class=MsoNormal style='margin-left:75.75pt;border:none;mso-border-left-alt:
solid #A0C6E5 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:black'>Hi <br>
Listers</span></font><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>,</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:75.75pt;border:none;mso-border-left-alt:
solid #A0C6E5 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><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:75.75pt;border:none;mso-border-left-alt:
solid #A0C6E5 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><span
class=emailstyle16><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.</span></font></span><font color=black><span
style='color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:75.75pt;border:none;mso-border-left-alt:
solid #A0C6E5 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><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:75.75pt;border:none;mso-border-left-alt:
solid #A0C6E5 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><span
class=emailstyle16><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. </span></font></span><font color=black><span
style='color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:75.75pt;border:none;mso-border-left-alt:
solid #A0C6E5 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:black'><br>
<span class=emailstyle16><font color=black>We are having major problem</font></span></span></font><span
class=emailstyle16><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>s</span></font></span><span
class=emailstyle16><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial'> with locking and deadlocks in this environment.</span></font></span><font
color=black><span style='color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:75.75pt;border:none;mso-border-left-alt:
solid #A0C6E5 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><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:75.75pt;border:none;mso-border-left-alt:
solid #A0C6E5 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><span
class=emailstyle16><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.</span></font></span><font
color=black><span style='color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:75.75pt;border:none;mso-border-left-alt:
solid #A0C6E5 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><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:75.75pt;border:none;mso-border-left-alt:
solid #A0C6E5 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><span
class=emailstyle16><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial'>Any suggestions would be greatly appreciated.</span></font></span><font
color=black><span style='color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:75.75pt;border:none;mso-border-left-alt:
solid #A0C6E5 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><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:75.75pt;border:none;mso-border-left-alt:
solid #A0C6E5 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><span
class=emailstyle16><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial'>Thanks</span></font></span><font color=black><span
style='color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:75.75pt;border:none;mso-border-left-alt:
solid #A0C6E5 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><span
class=emailstyle16><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial'>Sagar</span></font></span><font color=black><span
style='color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:75.75pt;border:none;mso-border-left-alt:
solid #A0C6E5 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><span
class=emailstyle16><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial'>TradePoint Systems</span></font></span><font
color=black><span style='color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:75.75pt;border:none;mso-border-left-alt:
solid #A0C6E5 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><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>
</div>
<div style='border:none;border-left:solid #A0C6E5 1.5pt;padding:0in 0in 0in 4.0pt'>
<p align=center style='margin-left:39.75pt;text-align:center;border:none;
mso-border-left-alt:solid #A0C6E5 1.5pt;padding:0in;mso-padding-alt:0in 0in 0in 4.0pt'><font
size=1 color=black face=Tahoma><span style='font-size:8.5pt;font-family:Tahoma;
color:black'><br>
</span></font><font size=1 color=black face=Tahoma><span
style='font-size:8.5pt;font-family:Tahoma;color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
</div>
<p class=MsoNormal style='margin-left:.5in'><font size=3 color=black
face="Times New Roman"><span style='font-size:12.0pt;color:black'><br
clear=all style='mso-special-character:line-break'>
</span></font><font color=black><span style='color:black;mso-color-alt:windowtext'><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=2 width="100%" align=center>
</span></font></div>
<p class=MsoNormal style='margin-left:.5in'><font size=3 color=black
face="Times New Roman"><span style='font-size:12.0pt;color:black'>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*</span></font><font color=black><span
style='color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></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>