<html>
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 10 (filtered)">
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
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:purple;
text-decoration:underline;}
span.EmailStyle17
{font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
/* List Definitions */
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=3 color=navy face="Times New Roman"><span
style='font-size:12.0pt;color:navy'>Hi ,</span></font></p>
<p class=MsoNormal><font size=3 color=navy face="Times New Roman"><span
style='font-size:12.0pt;color:navy'>Would anyone be able to show me how to
speed up data exporting from AIX to MSSQL?</span></font></p>
<p class=MsoNormal><font size=3 color=navy face="Times New Roman"><span
style='font-size:12.0pt;color:navy'>It takes around 24 hours to export the data
</span></font></p>
<p class=MsoNormal><font size=3 color=navy face="Times New Roman"><span
style='font-size:12.0pt;color:navy'> </span></font></p>
<p class=MsoNormal><font size=3 color=navy face="Times New Roman"><span
style='font-size:12.0pt;color:navy'>Here is my set up:</span></font></p>
<p class=MsoNormal><font size=3 color=navy face="Times New Roman"><span
style='font-size:12.0pt;color:navy'> </span></font></p>
<ol start=1 type=1>
<li class=MsoNormal style='color:navy'><font size=3 color=navy
face="Times New Roman"><span style='font-size:12.0pt'>Powerhouse with
CISAM file on AIX</span></font></li>
<li class=MsoNormal><font size=3 color=navy face="Times New Roman"><span
style='font-size:12.0pt;color:navy'>MSSQL DB is on Windows box </span></font> </li>
<li class=MsoNormal style='color:navy'><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial'>I am using Data Direct ODBC
driver to connect to the MSSQL db from the AIX box and</span></font></li>
<li class=MsoNormal style='color:navy'><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial'>we’re on a 1gigabit network.</span></font></li>
<li class=MsoNormal style='color:navy'><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial'>Here is a qtp run sample:</span></font></li>
</ol>
<p class=MsoNormal style='margin-left:.25in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>set process nolimit</span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>commit at request</span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>set input nolimit</span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>use setlimit</span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>request abadj</span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>access abadj alias oldabadj</span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>output abadj in sqldevl add</span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>request abadjdesc</span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>access abadjdesc alias oldabadjdesc</span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>output abadjdesc in sqldevl add</span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>request abadjdet</span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>access abadjdet alias oldabadjdet</span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>output abadjdet in sqldevl add</span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>;request abapprover</span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>;access abapprover alias oldabapprover</span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>;output abapprover in sqldevl add</span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>request abbudexp</span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>access abbudexp alias oldabbudexp</span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>output abbudexp in sqldevl add</span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>request abbudgroup</span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>access abbudgroup alias oldabbudgroup</span></font></p>
<p class=MsoNormal style='margin-left:.25in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>output abbudgroup in sqldevl add</span></font></p>
</div>
</body>
</html>