Quick Beginnings

Chapter 9. Configuring DRDA Host Connections on OS/2 or Windows NT Workstations

If you have installed the Client Configuration Assistant on your workstation, you can use this tool to configure your DB2 Connect workstation to access host or OS/400 databases. Although the Client Configuration Assistant provides three methods to configure connection to DB2 Universal Database databases, you must use the "Manual" method to define a connection to a DRDA database. Perform the following steps:

1. If the Client Configuration Assistant is not already running, start it: Click on Start and select Programs->DB2 for Windows 95 or Windows NT->Client Configuration Assistant. You are presented with a Welcome panel.

   Note:

   The Welcome panel appears whenever you use the Client Configuration Assistant and have no databases cataloged.

2. Click on the Add Database push button to configure connections using the Add Database SmartGuide.

3. Select the Manually configure a connection to a DB2 database radio button, then click on the Next push button.

4. Choose the protocol you want to use, either APPC or TCP/IP:

   • If you want to use APPC:

     1. Select APPC as the protocol for the connection, then select the Target Operating System for the host to which you want to connect. Click on the Next push button.

     2. You need to enter a Symbolic destination name:

        • If you have already defined a symbolic destination (also known as the CPI-C side information), for the database to which you will be connecting, type in the Symbolic destination name, then click on the Configure push button.

        • If the Configure push button is greyed and cannot be selected, it means that the CCA cannot guide you through the process of defining a symbolic destination name for your database, and you will need to configure this manually. If your SNA product is one of those described in this manual, go to those configuration instructions now. (Refer to Chapter 11. "Configuring Communications to Host and AS/400 Databases Manually" for a list of the SNA products that are described.) Otherwise, you need to use the documentation supplied with your SNA product to configure the CPI-C name (symbolic destination). When you have defined the symbolic destination for the database, come back to this CCA page and type in the name. Then skip to step 5.

     3. Select either the APPC (SNA) radio button or the APPC over TCP/IP radio button, then click on the Next push button. You are presented with two new pages.

     4. Fill in the fields on the This PC page and the Server page. (In most situations you do not need to fill in values for the Session section.) Click on the Done push button.

   • If you want to use TCP/IP:

     1. Select TCP/IP as the protocol for the connection, then select the Target Operating System for the host to which you want to connect.

     2. Click on the Next push button.

     3. Fill in the Hostname and Port Number fields. Optionally, fill in the Service Name field. Click on the Next push button.

5. On the Target Database page, fill in the requested value, then click on the Next push button.

6. Fill in values for the Alias page, and, if you want to run ODBC applications, the ODBC page. Click on the Done push button to complete the definition.

7. Click on the Test Connection push button to test the connection to the specified database.

8. Enter your user ID and password if needed to access the database and click on the OK push button. If the connection is successful, a message confirming the connection appears. If not, refer to the Troubleshooting Guide for possible causes. You are now able to use the database.

9. It is strongly recommended that you bind DB2 utilities to the database you just defined. To do this:

   1. Select the database to which you want to bind the utilities.

   2. Click on the Bind push button.

   3. Select whether you want to bind utilities or applications.

   4. Click on the Continue push button.

   5. Enter a user ID and password to connect to the database. The user ID must have the authority to bind new packages against the database.

   6. Select the utilities you want to bind and click on OK.

   If you want to access another database, select the Add Another push button.

Now that you have configured host connections, go to Chapter 26. "Installing DB2 Clients" to install DB2 clients.

[ DB2 List of Books | Search the DB2 Books ]