Working described for IBM Driver:
EXEC master.dbo.sp_addlinkedserver @server = N'DB2IBM', @srvproduct=N'IBMADB2.DB2COPY1', @provider=N'IBMDADB2.DB2COPY1', @provstr=N'Initial_Catalog=PROMO;Database=PROMO; Hostname=xxx.xxx.xxx.xxx;Port=50000;UID=promo;password=xxx'
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'DB2IBM',@useself=N'False',@locallogin=NULL,@rmtuser=N'promo',@rmtpassword='########'
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'DB2IBM',@useself=N'False',@locallogin=N'sa',@rmtuser=N'promo',@rmtpassword='########'
Working described for MS Driver:
EXEC master.dbo.sp_addlinkedserver @server = N'DB2MS', @srvproduct=N'DB2OLEDB', @provider=N'DB2OLEDB', @datasrc=N'DB282', @provstr=N'Provider=DB2OLEDB;User ID=promo;Password=xxx;Initial Catalog=PROMO;Network Transport Library=TCP;Host CCSID=1251;PC Code Page=1251;Network Address=xxx.xxx.xxx.xxx;Network Port=50000;Process Binary as Character=False;Units of Work=RUW;DBMS Platform=DB2/Linux;Defer Prepare=False;Rowset Cache Size=0;Persist Security Info=True;Connection Pooling=True;Derive Parameters=False;Package Collection=YOUR_SCHEMA;'
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'DB2MS',@useself=N'False',@locallogin=NULL,@rmtuser=N'promo',@rmtpassword='########'
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'DB2MS',@useself=N'False',@locallogin=N'sa',@rmtuser=N'promo',@rmtpassword='########'