<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2900.3020" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=609402418-29012007><FONT face=Arial color=#0000ff size=2>Blue
is correct.</FONT></SPAN></DIV>
<DIV><SPAN class=609402418-29012007><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=609402418-29012007><FONT face=Arial color=#0000ff size=2>When
we converted from HP3000 to AIX/Oracle we did the same
thing.</FONT></SPAN></DIV>
<DIV><SPAN class=609402418-29012007><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=609402418-29012007><FONT face=Arial color=#0000ff size=2>Loaded
the tables without any indexes and built the indexes
afterwards.</FONT></SPAN></DIV>
<DIV><SPAN class=609402418-29012007><FONT face=Arial color=#0000ff size=2>It was
like night and day.</FONT></SPAN></DIV>
<DIV><SPAN class=609402418-29012007><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=609402418-29012007><FONT face=Arial color=#0000ff size=2>Good
luck Viet</FONT></SPAN></DIV>
<DIV><SPAN class=609402418-29012007><FONT face=Arial color=#0000ff
size=2>Ken</FONT></SPAN></DIV>
<DIV><SPAN class=609402418-29012007><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
powerh-l-bounces+ken.langendock=rogers.com@lists.sowder.com
[mailto:powerh-l-bounces+ken.langendock=rogers.com@lists.sowder.com] <B>On
Behalf Of </B>Robert Edis<BR><B>Sent:</B> January 29, 2007 1:18 PM<BR><B>To:</B>
powerh-l@lists.sowder.com<BR><B>Subject:</B> RE: migrating
data<BR><BR></FONT></DIV><BR><FONT face=sans-serif size=2>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.</FONT> <BR><BR><FONT face=sans-serif size=2>Blue</FONT>
<BR><BR><BR><BR><BR><TT><FONT size=2>From:
powerh-l-bounces+atla38=dsl.pipex.com@lists.sowder.com<BR>[mailto:powerh-l-bounces+atla38=dsl.pipex.com@lists.sowder.com]
On Behalf Of<BR>Viet Nguyen<BR>Sent: 29 January 2007 16:07<BR>To:
powerh-l@lists.sowder.com<BR>Subject: migrating data<BR><BR><BR><BR>Hi
,<BR><BR>Would anyone be able to show me how to speed up data exporting from AIX
to<BR>MSSQL?<BR><BR>It takes around 24 hours to export the data
<BR><BR><BR><BR>Here is my set up:<BR><BR><BR><BR>1.
Powerhouse with CISAM file on AIX<BR>2.
MSSQL DB is on Windows box
<BR>3. I am using
Data Direct ODBC driver to connect to the MSSQL db from<BR>the AIX box and<BR>4.
we're on a 1gigabit
network.<BR>5. Here is a
qtp run sample:<BR><BR><BR><BR><BR><BR>set process nolimit<BR><BR>commit at
request<BR><BR>set input nolimit<BR><BR><BR><BR>use
setlimit<BR><BR><BR><BR>request abadj<BR><BR>access abadj alias
oldabadj<BR><BR>output abadj in sqldevl add<BR><BR><BR><BR>request
abadjdesc<BR><BR>access abadjdesc alias oldabadjdesc<BR><BR>output abadjdesc in
sqldevl add<BR><BR><BR><BR>request abadjdet<BR><BR>access abadjdet alias
oldabadjdet<BR><BR>output abadjdet in sqldevl add<BR><BR><BR><BR>;request
abapprover<BR><BR>;access abapprover alias oldabapprover<BR><BR>;output
abapprover in sqldevl add<BR><BR><BR><BR>request abbudexp<BR><BR>access abbudexp
alias oldabbudexp<BR><BR>output abbudexp in sqldevl add<BR><BR><BR><BR>request
abbudgroup<BR><BR>access abbudgroup alias oldabbudgroup<BR><BR>output abbudgroup
in sqldevl add<BR><BR><BR><BR></FONT></TT><BR></BODY></HTML>