Home > IT Answers > AS/400 > Improve performance on Insert rows into DB2 400 table from SQL server
Code2live
55 pts.
 Improve performance on Insert rows into DB2 400 table from SQL server
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
ASKED: June 15, 2010  2:58 PM
UPDATED: October 29, 2010  12:38 AM
RELATED QUESTIONS
Answer Wiki:
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.
Last Wiki Answer Submitted:  October 28, 2010  5:17 pm  by  Pdog   15 pts.
All Answer Wiki Contributors:  Pdog   15 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

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?

Meandyou
 5,205 pts.
 

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

philpl1jb
 44,190 pts.
 

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

philpl1jb
 44,190 pts.