Improve performance on Insert rows into DB2 400 table from SQL server

55 pts.
Tags:
AS/400
DB2/400
Linked servers
SQL Server
SQL Server 2005
Using INSERT OPENQUERY and a linked server on SQL Svr 2005, to insert rows to DB2 table on AS400. To a local AS400 runs very quickly. Performance on a remote 400 is very slow, and seems to be out of proportion to the change in line speed. Is there anyway to improve the performance for Inserts to remote 400 db2?

Software/Hardware used:
MSSQL Server 2005 64bit, iServer V5R4

Answer Wiki

Thanks. We'll let you know when a new response is added.

This is a question rather than an answer. I need to do exactly the same thing. I can update data on my server from the remote 400 but cannot move data from the server to the remote 400.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Meandyou
    The only thought I have is to limit the number of times you have to go across that wire. So instead of doing multiple INSERTs, can you do multi-row INSERTS, thereby lowering the number of calls to the database and the number of times to go across the network?
    5,220 pointsBadges:
    report
  • philpl1jb
    performance would be related to the load on the system, the file, the journal and the system hardware. Also the number of logical files over the file(s) being transfered. Phil
    49,850 pointsBadges:
    report
  • philpl1jb
    Normap22 - I think you should start a new string .. few people will see this. The original problem was slow updates but it sounds like you're not getting updates at all. Phil
    49,850 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following