Installing and Configuring DB2 Clients

Chapter 9. Configuring Client to DB2 Server Communications Using the CCA

Use the information in this section to use the Client Configuration Assistant to configure OS/2, Windows 95, and Windows NT workstations to access remote DB2 Universal Database servers. To configure all other clients, see Chapter 10. "Configuring Client-to-Server Communications Using the Command Line Processor".

Use the Client Configuration Assistant to configure your OS/2, Windows 95, or Windows NT client workstation to access remote DB2 Universal Database servers. The Client Configuration Assistant provides three configuration methods: one makes use of a server's access profile, one searches the network for databases, and the other requires that you enter the database name and the communication protocol values of the DB2 server.

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

1. Start the Client Configuration Assistant (CCA).

   For OS/2:

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

   For Windows 95 or Windows NT:

   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 with a file containing database access information, select the Use an access profile radio button and click on the Next push button.

     1. Click on the Browse push button to select an access profile, or enter the path and name of the file in the File field.

     2. You are presented with a list of systems, instances, and databases. Select the database that you want to use 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.
     

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

     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 the 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.

     3. If the system that contains the database that you want 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 the 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.

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

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

   • 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. Click on the Next push button.

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

     3. Specify the name of the database that you want to connect to in the Target database field and proceed to Step 3.

3. To specify the database alias name or to add a description, click on the Next push button. If you do not specify a database alias name, the default will be the same as the database 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, select the Register this database for ODBC check box, select the radio button that describes the type of data source that you want to register this database as, and select the application that you want to use from the Application drop down box. Click on the Done push button to finish using the Add Database SmartGuide.

6. The Confirmation window opens. Click on the Test Connection push button to test the connection to the specified 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 the database. If you want to access another database, select 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 ]