Configuring Server Access

Once you have configured the primary and remote servers, use the following procedure to configure access:

1. From the Client Options dialog box, Connect tab, configure the following:

   Control Group	Control Name	Value
   Network Info	Server Name	A new server name
   	Communication Protocol	TCP/IP
   	IP Address	The remote machine name or its IP address
   	TCP Port	Port to use on the remote machine (8898 is the default)
   Connect To	Locations	A unique name for the remote location, different from all local location names

2. Click OK.
3. Using SQL Wizard, attempt to log onto the remote server. If you are not successful, verify that your settings are correct. To do this:
   1. At a command prompt, use the Windows ping command to verify that the machine name or IP address in the IP Address field is correct and can be resolved. If this doesn't work, verify with IT that the machine name or IP address can be resolved and the destination is reachable.
   2. At a command prompt, use the Windows telnet command to verify that you can establish a connection to the server (telnet machine port). If a connection is refused:
      • Verify that the remote server is running
      • Using the IPCONFIG on the remote machine, verify that the machine name/IP Address is valid
      • Using the NETSTAT command, verify that the server is running and listening on the proper port
      • Ensure that your firewall software isn't preventing the connection
4. From the Connect tab on the Options dialog box, set the Server Name back to your local server; then click OK.
5. From SQL Wizard, enter the following INSERT statements to add the server location to the local servers SYSTEM location:

   INSERT INTO SYSTEM.SYSIBM.SYSLUNAMES (LUNAME) VALUES (" ServerName ");

   INSERT INTO SYSTEM.SYSIBM.SYSLOCATIONS VALUES (" LocationName ","X", " ServerName ","T");

   where ServerName is the server name you specified in step 1, and LocationName is the name of the remote location you specified in step 1.

6. Shut down and restart the local server to ensure that the local server picks up the new location.
7. Start SQLWizard on the local machine.

The new location should now appear on the list of locations in the Catalog Browser. The remote location should be accessible through the SQLWizard Catalog Browser and available for any program or utility connecting to the local server.