Server-to-Server Connectivity

Restriction: This topic applies to Windows environments only.

Server-to-server connectivity allows a client accessing one XDB Server to access data in a location controlled by another XDB Server in a distributed environment. Server-to-server connectivity works only with SQL Data Manipulation Language (DML) statements, such as INSERT, UPDATE, DELETE and SELECT. Location access is done interactively, either by using a three-part-name (location-name.authid.object-name) or alias, or by using the SET LOCATION command.

Server-to-server connectivity eliminates the need to change the client configuration settings to access a remote XDB Server or DB2 location (through XDB Link). In order to access a remote location, a system administrator must maintain the system tables to reflect known locations and server names. See the chapter Server-to-Server Connectivity for further information on using server-to-server connectivity for RUW and DUW, and for server-to-server setup options.