<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=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[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]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
p
{mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman";}
span.emailstyle16
{color:black;}
span.emailstyle17
{color:navy;}
span.EmailStyle21
{mso-style-type:personal;
font-family:Arial;
color:navy;}
span.EmailStyle22
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=blue>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Scenarios like this could be why SQLserver
have supplied the autoincrement option on the column. <o:p></o:p></span></font></p>
<p class=MsoNormal><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><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>I did some testing once, my notes are
below, but I don’t recall how rigorous the results were, only that the
use was happy and did’nt contact me again </span></font><font size=2
color=navy face=Wingdings><span style='font-size:10.0pt;font-family:Wingdings;
color:navy'>J</span></font><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><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><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><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>A summary of the required code for locking SQLserver rows at the
procedural level is below. <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>Care must be taken with this approach for the following reason, if a
sequential read to table getnext is active on another screen it is likely to
use a full table lock, this will prevent the designer procedure lokem, see
example below, from reading the row. Therefore access to the 'get-next' table
should be kept to a minimum at all times.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>If a second screen reads the table getnext by keyed/indexed access, and
as long as it is not reading the same row, there appears to be no access
conflict. If a second screen reads the same row, the serializable tx will
wait until the row is available. This is because the row is regarded as
uncommitted and the serializable tx reads using 'repeatable read'.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>If two screens attempt to run the designer procedure lokem, see example
below, a deadlock error will be issued to the screen which commits the
transaction latest. <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>This should rarely happen if access to the 'get-next' table is kept to
a minimum at all times.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>TRANSACTION lockem read write serializable<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>file getnext designer TRANSACTION lockem for query, process, update<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>proc designer lokem nodata<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>begin<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>start transaction lockem<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> GET getnext Via seg1 using "C"<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> LET seg2 of getnext = t_display<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> LET t_display = seg2 of getnext<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> PUT locktest<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>commit transaction lockem<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>display t_display <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>display seg2 of getnext<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>end<o:p></o:p></span></font></p>
<p class=MsoNormal><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>
<div>
<p><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>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=3 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>
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> 02 December 2005 14:51<br>
<b><span style='font-weight:bold'>To:</span></b> Peter Bateman<br>
<b><span style='font-weight:bold'>Cc:</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><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><span class=EmailStyle21><font size=2 color=navy face=Arial><span
style='font-size:10.0pt'>Hi Peter,<o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle21><font size=2 color=navy face=Arial><span
style='font-size:10.0pt'><o:p> </o:p></span></font></span></p>
<p class=MsoNormal style='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
face="Courier New"><span style='font-family:"Courier New"'><o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='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 face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"'><o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='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='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='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='text-autospace:none'><font size=2 color=red
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:red'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='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='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='text-autospace:none'><font size=2 color=red
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:red'> start transaction myupdate<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=red
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:red'> get shipment_dates via file_no,tracing_Date_no using
1,1<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=red
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:red'> if accessok<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=red
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:red'> then begin<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=red
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:red'> info
message=ascii(file_no) + " " + ascii(time_updated) now resp<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=red
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:red'> let
time_updated = time_updated + 1<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=red
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:red'> put
shipment_dates<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=red
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:red'> commit<o:p></o:p></span></font></p>
<p class=MsoNormal style='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='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='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='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='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 face="Courier New"><span style='font-size:
10.0pt;font-family:"Courier New"'><o:p></o:p></span></font></p>
<p class=MsoNormal style='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 face="Courier New"><span style='font-size:
10.0pt;font-family:"Courier New"'><o:p></o:p></span></font></p>
<p class=MsoNormal style='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 face="Courier New"><span style='font-size:
10.0pt;font-family:"Courier New"'><o:p></o:p></span></font></p>
<p class=MsoNormal style='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 face="Courier New"><span style='font-size:
10.0pt;font-family:"Courier New"'><o:p></o:p></span></font></p>
<p class=MsoNormal style='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 face="Courier New"><span style='font-size:
10.0pt;font-family:"Courier New"'><o:p></o:p></span></font></p>
<p class=MsoNormal style='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 face="Courier New"><span style='font-size:10.0pt;
font-family:"Courier New"'><o:p></o:p></span></font></p>
<p class=MsoNormal style='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
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"'><o:p></o:p></span></font></p>
<p class=MsoNormal><span class=EmailStyle21><font size=2 color=navy face=Arial><span
style='font-size:10.0pt'><o:p> </o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle21><font size=2 color=navy face=Arial><span
style='font-size:10.0pt'><o:p> </o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle21><font size=2 color=navy face=Arial><span
style='font-size:10.0pt'>Thanks for all the input and suggestions.<o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle21><font size=2 color=navy face=Arial><span
style='font-size:10.0pt'><o:p> </o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle21><font size=2 color=navy face=Arial><span
style='font-size:10.0pt'>Sagar<o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle21><font size=2 color=navy face=Arial><span
style='font-size:10.0pt'>TradePoint Systems <o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle21><font size=2 color=navy face=Arial><span
style='font-size:10.0pt'><o:p> </o:p></span></font></span></p>
<p class=MsoNormal style='margin-left:36.0pt'><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><o:p></o:p></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'><o:p> </o:p></span></font></p>
<p style='margin-left:36.0pt'><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><o:p></o:p></p>
<p style='margin-left:36.0pt'><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><o:p></o:p></p>
<p style='margin-left:36.0pt'><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><o:p></o:p></p>
<p style='margin-left:36.0pt'><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><o:p></o:p></p>
<p style='margin-left:36.0pt'><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 face=Tahoma><span style='font-size:
8.5pt;font-family:Tahoma'><o:p></o:p></span></font></p>
<p style='margin-left:36.0pt'><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 face=Tahoma><span style='font-size:8.5pt;font-family:Tahoma'><o:p></o:p></span></font></p>
<p style='margin-left:36.0pt'><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
face=Tahoma><span style='font-size:8.5pt;font-family:Tahoma'><o:p></o:p></span></font></p>
<p style='margin-left:36.0pt'><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 face=Tahoma><span
style='font-size:8.5pt;font-family:Tahoma'><o:p></o:p></span></font></p>
<p style='margin-left:36.0pt'><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 face=Tahoma><span style='font-size:8.5pt;
font-family:Tahoma'><o:p></o:p></span></font></p>
<p style='margin-left:36.0pt'><font size=1 color=black face=Tahoma><span
style='font-size:8.5pt;font-family:Tahoma;color:black'>
Peter</span></font><font size=1 face=Tahoma><span style='font-size:8.5pt;
font-family:Tahoma'><o:p></o:p></span></font></p>
<p style='margin-left:36.0pt'><font size=1 color=black face=Tahoma><span
style='font-size:8.5pt;font-family:Tahoma;color:black'> </span></font><font
size=1 face=Tahoma><span style='font-size:8.5pt;font-family:Tahoma'><o:p></o:p></span></font></p>
<p style='margin-left:36.0pt'><font size=1 color=black face=Tahoma><span
style='font-size:8.5pt;font-family:Tahoma;color:black'> </span></font><font
size=1 face=Tahoma><span style='font-size:8.5pt;font-family:Tahoma'><o:p></o:p></span></font></p>
<p style='margin-left:36.0pt'><font size=1 color=black face=Tahoma><span
style='font-size:8.5pt;font-family:Tahoma;color:black'> </span></font><font
size=1 face=Tahoma><span style='font-size:8.5pt;font-family:Tahoma'><o:p></o:p></span></font></p>
<p style='margin-left:36.0pt'><font size=1 color=black face=Tahoma><span
style='font-size:8.5pt;font-family:Tahoma;color:black'> </span></font><font
size=1 face=Tahoma><span style='font-size:8.5pt;font-family:Tahoma'><o:p></o:p></span></font></p>
<div style='mso-element:para-border-div;border:none;border-left:solid #A0C6E5 1.5pt;
padding:0cm 0cm 0cm 4.0pt;margin-left:75.75pt;margin-right:0cm'>
<p class=MsoNormal style='border:none;padding:0cm'><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><o:p></o:p></p>
<p class=MsoNormal style='border:none;padding:0cm'><font size=3 color=black
face="Times New Roman"><span style='font-size:12.0pt;color:black'> </span></font><o:p></o:p></p>
<p class=MsoNormal style='border:none;padding:0cm'><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><o:p></o:p></p>
<p class=MsoNormal style='border:none;padding:0cm'><font size=3 color=black
face="Times New Roman"><span style='font-size:12.0pt;color:black'> </span></font><o:p></o:p></p>
<p class=MsoNormal style='border:none;padding:0cm'><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><o:p></o:p></p>
<p class=MsoNormal style='border:none;padding:0cm'><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><o:p></o:p></p>
<p class=MsoNormal style='border:none;padding:0cm'><font size=3 color=black
face="Times New Roman"><span style='font-size:12.0pt;color:black'> </span></font><o:p></o:p></p>
<p class=MsoNormal style='border:none;padding:0cm'><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><o:p></o:p></p>
<p class=MsoNormal style='border:none;padding:0cm'><font size=3 color=black
face="Times New Roman"><span style='font-size:12.0pt;color:black'> </span></font><o:p></o:p></p>
<p class=MsoNormal style='border:none;padding:0cm'><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><o:p></o:p></p>
<p class=MsoNormal style='border:none;padding:0cm'><font size=3 color=black
face="Times New Roman"><span style='font-size:12.0pt;color:black'> </span></font><o:p></o:p></p>
<p class=MsoNormal style='border:none;padding:0cm'><span class=emailstyle16><font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial'>Thanks</span></font></span><o:p></o:p></p>
<p class=MsoNormal style='border:none;padding:0cm'><span class=emailstyle16><font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial'>Sagar</span></font></span><o:p></o:p></p>
<p class=MsoNormal style='border:none;padding:0cm'><span class=emailstyle16><font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial'>TradePoint
Systems</span></font></span><o:p></o:p></p>
<p class=MsoNormal style='border:none;padding:0cm'><font size=3 color=black
face="Times New Roman"><span style='font-size:12.0pt;color:black'> </span></font><o:p></o:p></p>
</div>
<div style='mso-element:para-border-div;border:none;border-left:solid #A0C6E5 1.5pt;
padding:0cm 0cm 0cm 4.0pt;margin-left:39.75pt;margin-right:0cm'>
<p align=center style='text-align:center;border:none;padding:0cm'><font size=1
color=black face=Tahoma><span style='font-size:8.5pt;font-family:Tahoma;
color:black'><br>
</span></font><font size=1 face=Tahoma><span style='font-size:8.5pt;
font-family:Tahoma'><o:p></o:p></span></font></p>
</div>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3 color=black
face="Times New Roman"><span style='font-size:12.0pt;color:black'><br
clear=all>
</span></font><o:p></o:p></p>
<div style='margin-left:36.0pt'>
<div class=MsoNormal align=center style='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>
</div>
<p class=MsoNormal style='margin-left:36.0pt'><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><o:p></o:p></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>