To configure a server as a primary XDB Server, you must update the system tables. In the examples, the primary XDB Server is xdbserve.
To update the system tables:
SET LOCATION TO system;
INSERT INTO sysibm.syslunames VALUES ("remote-server","","","","","");
where remote-server is the name of a remote XDB Server to be accessed. Several of the other columns in the SYSIBM.SYSLUNAMES table are used for security mapping. See the chapter Multiserver Security for more information on using these values.
In the examples , the SQL command:
INSERT INTO SYSIBM.SYSLUNAMES VALUES ("sales","","","","","");
would have been issued on the XDB Server XDBSERVE.
INSERT INTO SYSIBM.SYSLOCATIONS VALUES ("remote-location","X", "remote-server","link-type");
where:
remote-location | is the name of the remote location to be accessed (unique among all locations on all servers that are used in distributed processing). |
X | indicates it is an XDB Server. |
remote-server | is the name of the remote server that controls the remote location. |
link-type | is the communication protocol used to connect to the remote server. |
In the examples used in this topic, the SQL command:
INSERT INTO SYSIBM.SYSLOCATIONS VALUES ("orders","X","sales","B");
would have been issued on the XDB Server XDBSERVE.
REFRESH LOCATIONS;