How to add DB2 as a linked server in SQL

Here I am trying to add new linked server in SQL

-- Object:  LinkedServer [AS400DB]   
EXEC master.dbo.sp_addlinkedserver @server = N'AS400DB'
	,@srvproduct = N'AS400'
	,@provider = N'IBMDASQL'
	,@datasrc = N'10.0.1.1'


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

EXEC master.dbo.sp_serveroption @server = N'AS400DB'
	,@optname = N'collation compatible'
	,@optvalue = N'false'
GO

EXEC master.dbo.sp_serveroption @server = N'AS400DB'
	,@optname = N'data access'
	,@optvalue = N'true'
GO

EXEC master.dbo.sp_serveroption @server = N'AS400DB'
	,@optname = N'dist'
	,@optvalue = N'false'
GO

EXEC master.dbo.sp_serveroption @server = N'AS400DB'
	,@optname = N'pub'
	,@optvalue = N'false'
GO

EXEC master.dbo.sp_serveroption @server = N'AS400DB'
	,@optname = N'rpc'
	,@optvalue = N'true'
GO

EXEC master.dbo.sp_serveroption @server = N'AS400DB'
	,@optname = N'rpc out'
	,@optvalue = N'true'
GO

EXEC master.dbo.sp_serveroption @server = N'AS400DB'
	,@optname = N'sub'
	,@optvalue = N'false'
GO

EXEC master.dbo.sp_serveroption @server = N'AS400DB'
	,@optname = N'connect timeout'
	,@optvalue = N'0'
GO

EXEC master.dbo.sp_serveroption @server = N'AS400DB'
	,@optname = N'collation name'
	,@optvalue = NULL
GO

EXEC master.dbo.sp_serveroption @server = N'AS400DB'
	,@optname = N'lazy schema validation'
	,@optvalue = N'false'
GO

EXEC master.dbo.sp_serveroption @server = N'AS400DB'
	,@optname = N'query timeout'
	,@optvalue = N'0'
GO

EXEC master.dbo.sp_serveroption @server = N'AS400DB'
	,@optname = N'use remote collation'
	,@optvalue = N'true'
GO

EXEC master.dbo.sp_serveroption @server = N'AS400DB'
	,@optname = N'remote proc transaction promotion'
	,@optvalue = N'true'
GO


Spread the love

Leave a Comment