Administration Guide

Managing Remote Databases

The following section shows you how to:

• Add a remote system

• Add the instance you want to work with for that system

• Add the database you want to work with under that instance

DB2 first checks in the node directory (which contains an entry for all servers to which a database client can connect and the communications protocol used in the connection) to see if the remote system is already known. If the remote system is not known, with a system, instance, or database on a remote system, you need to set yourself up as a client to the remote system.

After you install DB2, you can use the Client Configuration Assistant to search the network for systems, instances, and databases and configure communications for them. You then add the remote system by cataloging it. This creates an entry for the system in the node directory so that its instances and databases can be made known. Next, you must add the instances and databases for the system by cataloging them to create an entry for them in the node directory and database directory, respectively. This creates an entry for them in the node directory and database directory, respectively). When the configuration is complete, the remote systems are displayed in the Control Center so that you can work with them.

To add a remote system:

1. From the Control Center, click mouse button 2 on the Systems object and select Add. The Add System window opens.

2. Enter the system name in the System name field.

   If the Discover configuration parameter for the instance is set to search and the discover comm configuration parameter is not blank, you can select Refresh to get a list of the remote systems. You can then select one of the systems from the list below the System name field.

3. Type the remote instance name in the Remote instance name field.

4. Select the type of operating system for the remote system from the Operating system list.

5. Select the protocol you want used for communications with the remote locations. For a local system, Local is automatically selected and is the only valid protocol. For the remote systems the possible protocols are:

   • APPC

   • IPX/SPX

   • NetBIOS

   • TCP/IP

   • Named pipe (on Windows NT and Windows 9x operating systems only)

   Only the protocols that the computer is currently set up for appear in the listbox.

6. Enter the appropriate protocol parameters.

7. Enter a comment to be associated with the system.

8. Click Apply to add the system to the node directory.

Next, add the instance you want to work with on that system:

1. From the Control Center, click mouse button 2 on the Instances object belonging to the system you just added.

2. Select Add. The Add Instance window opens.

3. Enter the required values in the fields.

4. Click the Refresh push button to have a list of existing instances displayed.

5. Select the instance you want to work with.

6. Click the Apply push button, then the Close push button.

Finally, add the database you want to work with under that instance:

1. From the Control Center, click mouse button 2 on the Databases object.

2. Click Add. The Add Database window opens.

3. Enter the database name, type of communication protocol, and, optionally, an alias. An alias in this case is an alternative name used to identify a database.

4. Click the Refresh push button to display a list of existing databases for that instance.

5. Select a database.

6. Click the Apply push button, then the Close push button.

[ DB2 List of Books | Search the DB2 Books ]