SQL - ADD IBM DB2 Linked Server

Way 1:

EXEC master.dbo.sp_addlinkedserver @server = N'DB2_APPLDB', @srvproduct=N'Microsoft OLE DB Provider for DB2', @provider=N'IBMDADB2.DB2COPY1', @datasrc=N'APPLDB', @location=N'(IP Addresss or Server name):50008', @provstr=N'DB2OLEDB'


EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'DB2_APPLDB',@useself=N'False',@locallogin=NULL,@rmtuser=N'##########',@rmtpassword='###################'

Way 2:

Surly it will help you to add db2 server as linked server. Before you add the Db2 Oledb linked server you should install IBM DB2 OLE DB PROVIDER in your system.