Quick Beginnings for DB2 Universal Database for UNIX

Chapter 13. Configuring Client-to-Server Communications Using the Client Configuration Assistant

The information in this section describes how to use the Client Configuration Assistant to configure OS/2 and Windows 32-bit operating systems to access remote DB2 Universal Database servers. To configure all other clients, see Chapter 14. Configuring Client-to-Server Communications Using the Command Line Processor.

Use the Client Configuration Assistant to configure your OS/2 and Windows 32-bit operating systems to access remote DB2 servers. The Client Configuration Assistant provides three configuration methods:

• One method makes use of a server's access profile

• One method searches the network for databases

• One method requires that you enter the database name and the communication protocol parameters for the DB2 server.

Perform the following steps to configure your workstation to access remote servers:

1. Start the Client Configuration Assistant.

   For OS/2:

   Double-click on the Client Configuration Assistant icon, located in the DB2 for OS/2 folder.

   For Windows 32-bit operating systems:

   Click on Start and select Programs->DB2 for Windows->Client Configuration Assistant.

   The Welcome panel opens each time you start the CCA, until you have added at least one database to your client.

2. Click on the Add Database or Add push button to configure connections using the Add Database SmartGuide. Choose one of the following configuration methods:

   • If your administrator provided you a server profile, select the Use an access profile radio button and click on the Next push button.

     1. Click on the Browse push button and select the appropriate access profile.

     2. You are presented with a list of systems, instances, and databases. Select the database that you want to add and proceed to Step 3.

   • If you want to search the network for databases, select the Search the network radio button and click on the Next push button.

     1. Click on the [+] sign beside the Known Systems icon to list all the systems known to your client.

     2. Click on the [+] sign beside a system to get a list of the instances and databases on it. Select the database that you want to add and proceed to Step 3.
        

        The Other Systems (Search the network) icon will only appear if the client's DISCOVER parameter is set to SEARCH (this is the default setting).

     3. If the system that contains the database that you want to add is not listed, click on the [+] sign beside the Other Systems (Search the network) icon to search the network for additional systems. Click on the [+] sign beside a system to get a list of the instances and databases in it. Select the database that you want to add and proceed to Step 3.

     4. If the system you want is still not listed, it can be added to the list of systems by clicking on the Add System push button. Enter the required communication protocol parameters for the remote Administration Server and click on OK. For more information, click on the Help push button.

        Select the database that you want to add and proceed to Step 3.
        

        The Client Configuration Assistant may be unable to detect the remote system if: The Administration Server DISCOVER configuration parameter on the remote system is set to DISCOVER=DISABLE. The DB2COMM registry value and the DISCOVER_COMM configuration parameter are not configured on the Administration Server of the remote system with a discovery protocol being used on the client (the client discovery protocol is specified by the DISCOVER_COMM configuration parameter in the client's configuration). The Administration Server is not running on the remote system. By default, the Discovery function will search the network for 40 seconds; this may not be long enough to detect the remote system. You can configure the DB2DISCOVERYTIME registry value to specify a longer period of time. The network that the Discovery request is running on may have been configured so that the Discovery request does not reach the remote system desired. If you are using NetBIOS as the Discovery protocol, you may need to configure the DB2NBDISCOVERRCVBUFS registry value to a larger value to enable the client to receive more concurrent Discovery replies.

   • If you have the protocol information for the database that you want to connect to, select the Manually configure a connection to a DB2 database radio button and click on the Next push button.

     1. Select the radio button that corresponds to the protocol that you want to use from the Protocol list and click on the Next push button. If you selected the TCP/IP or APPC radio button, select the radio button that corresponds to the type of system where the database that you are trying to connect to resides.

     2. Enter the required communication protocol parameters and click on the Next push button. For more information, click on the Help push button.

     3. Enter the database alias name of the database that you want to connect to in the Target database field and click on the Next push button.
     
     

     When a database is created on the remote server, if a database alias is not specified during database creation, the database is created with a database alias=database_name; otherwise, the database alias is the name specified.

3. To specify a local database alias name or to add a description, click on the Next push button. If you do not want to specify a database alias name, or add a description, click on the Done push button. If you do not specify a database alias name, the default will be the same as the remote database alias name.

4. If you want to run ODBC-enabled applications, click on the Next push button. If you do not plan to use ODBC, click on the Done push button to finish using the Add Database SmartGuide and proceed to Step 6.

5. If you are using ODBC applications:

   1. Select the Register this database for ODBC check box, if it is not pre-selected.

   2. Select the radio button that describes the type of data source that you want to register this database as. For more information, click on the Help push button.

   3. Click on the Application drop down box and select the application that you want to use.

   4. Click on the Done push button to finish using the Add Database SmartGuide and add the database that you selected.

6. The Confirmation window opens. Click on the Test Connection push button to test the connection to this database.

7. Enter your user ID and password to access the database and click on OK. If the connection is successful, a message confirming the connection appears. If the connection fails, click on the Help push button for more information. If you require additional information, refer to the Troubleshooting Guide.

8. You are now able to use this database. If you want to access another database, click on the Add Another push button. To finish using the Add Database SmartGuide, click on the Close push button.

[ DB2 List of Books | Search the DB2 Books ]