Primary Server Configuration

Restriction: This topic applies to Windows environments only.

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:

Note:

Do not delete any seemingly empty records; these contain space characters in some columns and refer to locations controlled by your local XDB Server.

  1. On any client logged in to the primary XDB Server, start SQL Wizard (Windows) or Interactive SQL Utility (UNIX).
  2. Log in with an AuthID that has super user privileges, such as the INSTALL AuthID, provided with the XDB Server.
  3. Open an SQL Window and set the current location to the SYSTEM location:

    SET LOCATION TO system;

  4. Issue the following SQL command to insert information about a remote server into the SYSIBM.SYSLUNAMES table:
    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 used in this topic, the SQL command:

    INSERT INTO sysibm.syslunames 
        VALUES ("sales","","","","","");

    would have been issued on the XDB Server XDBSERVE.

  5. Issue the following SQL command to insert information about a remote location into the SYSIBM.SYSLOCATIONS table:
    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.

  6. Repeat Steps 4 and 5 for each remote XDB Server and location that will be accessed from this primary server.
  7. Issue the following SQL command to refresh the system:
    REFRESH LOCATIONS;
  8. Exit SQL Wizard (Windows) or Interactive SQL Utility (UNIX).