When using a linked server in SQL Server to upload an IBM i database file what provider usually has the best performance - my own tests show that Microsoft OLE DB Provider for ODBC drivers performs better than IBM DB2 for i IBMDASQL OLE DB provider; IBM DB2 for i IBMDA400 OLE DB provider and IBM DB2 for i IBMDARLA OLE DB provider.
Pinned topic IBM i upload to SQL server performance
Mike_DBA 120000EAG55 PostsACCEPTED ANSWER
Re: IBM i upload to SQL server performance2014-08-21T17:25:20Z in response to jonesy_burt
It's been a while since I've implemented a new instance of this, but in the past, I've always had best performance and the fewest problems using the ODBC provider. Do not use IBMDARLA for a linked server and I wouldn't bother with IBMDA400.