migrating data

[Robert Edis]

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.

Blue




From: powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com
[mailto:powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com] On Behalf 
Of
Viet Nguyen
Sent: 29 January 2007 16:07
To: powerh-l at lists.sowder.com
Subject: migrating data

 

Hi ,

Would anyone be able to show me how to speed up data exporting from AIX to
MSSQL?

It takes around 24 hours to export the data 

 

Here is my set up:

 

1.               Powerhouse with CISAM file on AIX
2.               MSSQL DB is on Windows box 
3.               I am using Data Direct ODBC driver to connect to the 
MSSQL db from
the AIX box and
4.               we're on a 1gigabit network.
5.               Here is a qtp run sample:

 

 

set process nolimit

commit at request

set input   nolimit

 

use setlimit

 

request abadj

access abadj alias oldabadj

output abadj in sqldevl add

 

request abadjdesc

access abadjdesc alias oldabadjdesc

output abadjdesc in sqldevl add

 

request abadjdet

access abadjdet alias oldabadjdet

output abadjdet in sqldevl add

 

;request abapprover

;access abapprover alias oldabapprover

;output abapprover in sqldevl add

 

request abbudexp

access abbudexp alias oldabbudexp

output abbudexp in sqldevl add

 

request abbudgroup

access abbudgroup alias oldabbudgroup

output abbudgroup in sqldevl add




-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20070129/0625d237/attachment.htm