<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 10 (filtered)">
<title>Message</title>
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:sans-serif;
panose-1:0 0 0 0 0 0 0 0 0 0;}
/* 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;}
tt
{font-family:"Courier New";}
span.EmailStyle18
{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;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Thank you all – I will remove my
index files – If this doesn’t work well enough I will try the bulk
insert with portable files.</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Viet.</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'>-----Original Message-----<br>
<b><span style='font-weight:bold'>From:</span></b> powerh-l-bounces+vnguyen=wsboces.org@lists.sowder.com
[mailto:powerh-l-bounces+vnguyen=wsboces.org@lists.sowder.com] <b><span
style='font-weight:bold'>On Behalf Of </span></b>Ken Langendock<br>
<b><span style='font-weight:bold'>Sent:</span></b> Monday, January 29, 2007
1:27 PM<br>
<b><span style='font-weight:bold'>To:</span></b> 'Robert Edis';
powerh-l@lists.sowder.com<br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: migrating data</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
<div>
<p class=MsoNormal style='margin-left:.5in'><font size=2 color=blue face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:blue'>Blue is correct.</span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:.5in'><font size=2 color=blue face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:blue'>When we converted from
HP3000 to AIX/Oracle we did the same thing.</span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:.5in'><font size=2 color=blue face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:blue'>Loaded the tables without
any indexes and built the indexes afterwards.</span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:.5in'><font size=2 color=blue face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:blue'>It was like night and
day.</span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:.5in'><font size=2 color=blue face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:blue'>Good luck Viet</span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:.5in'><font size=2 color=blue face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:blue'>Ken</span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
</div>
<p class=MsoNormal style='margin-right:0in;margin-bottom:12.0pt;margin-left:
.5in'><font size=2 face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>-----Original
Message-----<br>
<b><span style='font-weight:bold'>From:</span></b>
powerh-l-bounces+ken.langendock=rogers.com@lists.sowder.com
[mailto:powerh-l-bounces+ken.langendock=rogers.com@lists.sowder.com] <b><span
style='font-weight:bold'>On Behalf Of </span></b>Robert Edis<br>
<b><span style='font-weight:bold'>Sent:</span></b> January 29, 2007 1:18 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: migrating data</span></font></p>
<p class=MsoNormal style='margin-right:0in;margin-bottom:12.0pt;margin-left:
.5in'><font size=3 face="Times New Roman"><span style='font-size:12.0pt'><br>
</span></font><font size=2 face=sans-serif><span style='font-size:10.0pt;
font-family:sans-serif'>Does the recieving table have a unique index on the
primary key column? Even though you are doing an add and no update the
database engine still has to confirm that you are not entering a duplicate row
if a unique PK has been defined. If it has and you know that the new data
has a PK that does not already exist in the table then I suggest you drop the
PK index before the load and rebuild it afterwards.</span></font> <br>
<br>
<font size=2 face=sans-serif><span style='font-size:10.0pt;font-family:sans-serif'>Blue</span></font>
<br>
<br>
<br>
<br>
<br>
<tt><font size=2 face="Courier New"><span style='font-size:10.0pt'>From:
powerh-l-bounces+atla38=dsl.pipex.com@lists.sowder.com</span></font></tt><font
size=2 face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"'><br>
<tt><font face="Courier New">[mailto:powerh-l-bounces+atla38=dsl.pipex.com@lists.sowder.com]
On Behalf Of</font></tt><br>
<tt><font face="Courier New">Viet Nguyen</font></tt><br>
<tt><font face="Courier New">Sent: 29 January 2007 16:07</font></tt><br>
<tt><font face="Courier New">To: powerh-l@lists.sowder.com</font></tt><br>
<tt><font face="Courier New">Subject: migrating data</font></tt><br>
<br>
<br>
<br>
<tt><font face="Courier New">Hi ,</font></tt><br>
<br>
<tt><font face="Courier New">Would anyone be able to show me how to speed up
data exporting from AIX to</font></tt><br>
<tt><font face="Courier New">MSSQL?</font></tt><br>
<br>
<tt><font face="Courier New">It takes around 24 hours to export the data </font></tt><br>
<br>
<br>
<br>
<tt><font face="Courier New">Here is my set up:</font></tt><br>
<br>
<br>
<br>
<tt><font face="Courier New">1.
Powerhouse with CISAM file on AIX</font></tt><br>
<tt><font face="Courier New">2.
MSSQL DB is on Windows box </font></tt><br>
<tt><font face="Courier New">3.
I am using Data Direct ODBC driver to connect to the MSSQL db
from</font></tt><br>
<tt><font face="Courier New">the AIX box and</font></tt><br>
<tt><font face="Courier New">4.
we're on a 1gigabit network.</font></tt><br>
<tt><font face="Courier New">5.
Here is a qtp run sample:</font></tt><br>
<br>
<br>
<br>
<br>
<br>
<tt><font face="Courier New">set process nolimit</font></tt><br>
<br>
<tt><font face="Courier New">commit at request</font></tt><br>
<br>
<tt><font face="Courier New">set input nolimit</font></tt><br>
<br>
<br>
<br>
<tt><font face="Courier New">use setlimit</font></tt><br>
<br>
<br>
<br>
<tt><font face="Courier New">request abadj</font></tt><br>
<br>
<tt><font face="Courier New">access abadj alias oldabadj</font></tt><br>
<br>
<tt><font face="Courier New">output abadj in sqldevl add</font></tt><br>
<br>
<br>
<br>
<tt><font face="Courier New">request abadjdesc</font></tt><br>
<br>
<tt><font face="Courier New">access abadjdesc alias oldabadjdesc</font></tt><br>
<br>
<tt><font face="Courier New">output abadjdesc in sqldevl add</font></tt><br>
<br>
<br>
<br>
<tt><font face="Courier New">request abadjdet</font></tt><br>
<br>
<tt><font face="Courier New">access abadjdet alias oldabadjdet</font></tt><br>
<br>
<tt><font face="Courier New">output abadjdet in sqldevl add</font></tt><br>
<br>
<br>
<br>
<tt><font face="Courier New">;request abapprover</font></tt><br>
<br>
<tt><font face="Courier New">;access abapprover alias oldabapprover</font></tt><br>
<br>
<tt><font face="Courier New">;output abapprover in sqldevl add</font></tt><br>
<br>
<br>
<br>
<tt><font face="Courier New">request abbudexp</font></tt><br>
<br>
<tt><font face="Courier New">access abbudexp alias oldabbudexp</font></tt><br>
<br>
<tt><font face="Courier New">output abbudexp in sqldevl add</font></tt><br>
<br>
<br>
<br>
<tt><font face="Courier New">request abbudgroup</font></tt><br>
<br>
<tt><font face="Courier New">access abbudgroup alias oldabbudgroup</font></tt><br>
<br>
<tt><font face="Courier New">output abbudgroup in sqldevl add</font></tt><br>
<br>
<br>
<br>
</span></font></p>
</div>
</body>
</html>