IBM Books

Quick Beginnings for OS/2 and Windows NT

Step 2. Update the APPC Profiles on the DB2 Connect Workstation

Use the completed worksheet in Table 9 to configure DB2 Connect APPC communications for access to a remote host or AS/400 database server.

Figure car not displayed.
Go to the sections that describe how to configure APPC communications on the platforms that are present in your network:

Configuring IBM eNetwork Communications Server for Windows NT SNA API Client

Read this section if you have a Windows NT workstation that has IBM eNetwork Communications Server for Windows NT SNA API Client Version 5.0 or higher installed and you want to connect to an IBM eNetwork Communications Server for Windows NT server.

The Communications Server for Windows NT server and its SNA API client act as a split client. This configuration requires that you have an APPC-enabled application (such as DB2 Connect) running on the SNA API client workstation.



Figure hint not displayed.
The instructions in this section use a Windows NT client. The instructions for other supported operating systems are similar; refer to your Communications Server for Windows NT documentation for more information.

To configure the Windows NT SNA API client for APPC communications, complete the following steps:

Step  1.

Create a user account for the SNA API client on the Communications Server for Windows NT server

  1. Click on the Start button and select Programs->Administrative Tools (Common)->User Manager. The User Manager window opens.

  2. Select Users->New User from the menu bar. The New User window opens.

  3. Fill in the fields for the new SNA client user accout. For more information, refer to the Windows NT online help.

  4. Ensure that this user account is a member of the Administrators, IBMCSADMIN, and IBMCSAPI groups:

    1. Click on the Groups push button

    2. Select a group from the Not member of box and click on the <- Add push button. Repeat this step for each group that your user account must belong to.

  5. Click on OK.

  6. Click on the Add push button.

Step  2.

Start the configuration GUI for the IBM eNetwork CS/NT SNA API Client. Click on the Start push button and select Programs->IBM Communications Server SNA Client->Configuration. The CS/NT SNA Client Configuration window opens.
Configuration Options Screen

Step  3.

Configure Global Data

  1. In the Configuration options box, select the Configure Global Data option and click on the New push button. The Define Global Data window opens.

  2. Enter the user name for the SNA API client in the User name field. This is the user name that was defined in Step 1.

  3. Enter the password for the user account in the Password and Confirm Password fields.

  4. Click on OK.

Step  4.

Configure APPC Server List

  1. In the Configuration options box, select the Configure APPC Server List option. Click on the New push button. The Define APPC Server list window appears.

  2. Type in the IP address of the server (for example, 123.123.123.123).

  3. Click on OK.

Step  5.

Configure CPI-C Side Information

  1. In the Configuration options box, select the Configure CPI-C side information option and click on the New push button. The Define CPI-C side information window opens.

  2. Enter the symbolic destination name ((16)) in the Symbolic destination name field.

  3. Enter your Local LU alias ((12)) in the Local LU alias field.

  4. Enter the mode name ((15)) in the Mode name field.

  5. Enter the transaction program name ((17)) in the TP name field.

  6. Select the For SNA API Client use check box for this transaction program.

  7. Enter the network ID ((3)) and partner LU name ((2)) in the Partner LU name field.

  8. Click on OK.

Step  6.

Save the Configuration

  1. Select File->Save As from the menu bar. The Save As window opens.

  2. Type in a file name, and click on the Save push button.



Figure car not displayed.
You now need to update the DB2 directories, bind utilities and applications to the server, and test the connection.

The easiest way to do this is to use the Client Configuration Assistant (CCA). For more information on using the CCA, go to Configuring DB2 Connect to Host or AS/400 Communications Using the CCA. However, you can also perform these steps manually, as described in Step 3. Catalog the APPC or APPN Node and the sections that follow.

Configuring Microsoft SNA Server for Windows NT

This section describes how to configure Microsoft SNA Server Version 4.0 for Windows NT on your DB2 Connect workstation to connect to host or AS/400 database servers using APPC. Although Microsoft SNA Server will run on Windows NT 4.0 Workstation, Windows NT 4.0 Server is recommended.

Figure car not displayed.
For instructions on how to configure Microsoft SNA Client for Windows NT, go to Configuring Microsoft SNA Client.

You can define the properties of your SNA connections in the Microsoft SNA Server Manager (Server Manager). The Server Manager uses an interface similar to that of the Windows NT Explorer. The following illustration shows the interface. There are two panes in the main window of the Server Manager. All the configuration options we will be using can be accessed by right-clicking on objects in the left-hand pane of the window. Every object has a context menu that you can access by right-clicking on the object.

To configure APPC communications for use by DB2 Connect using Microsoft SNA Server Manager, perform the following steps:

Step  1.

Start the Server Manager by clicking on the Start button and selecting Programs->Microsoft SNA Server->Manager. The Microsoft SNA Server Manager window opens.
The Server Manager

Step  2.

Define the control point name

  1. Click on the [+] sign beside the Servers folder.

  2. Right-click on SNA Service folder and select the Properties option. The Properties window opens.

  3. Enter the correct NETID ((9)) and Control Point Name ((10)) in the corresponding fields.

  4. Click on OK.

Step  3.

Define the link service (802.2)

  1. Right-click on the SNA Service icon and select the Insert->Link Service option. The Insert Link Service window opens.
    Insert Link Service

  2. Select DLC 802.2 Link Service.

  3. Click on the Add push button.

  4. Click on the Finish push button.

Step  4.

Define the connection properties

  1. Right-click on SNA Service and select the Insert->Connection->802.2 option. The Connection Properties window opens.
    Connection Properties Window

  2. Enter a connection name ((7)) in the Name field.

  3. Click on the Link Service drop-down box and select the SnaDlc1 option.

  4. Select the Remote End radio button from the Host System box.

  5. Select the Both Directions radio button from the Allowed Directions box.

  6. Select the On Server Startup radio button from the Activation box.

  7. Select the Address tab.
    Connection Properties - Address

  8. Fill in the Remote Network Address field ((8)). Accept the default numbers in the other fields.

  9. Select the System Identification tab.

  10. Enter the following information:

    1. For the Local Node Name, add the Network ID ((9)), the Local PU Name ((10)), and the Local Node ID ((1) plus (14)). Accept the XID Type default.

    2. For the Remote Node Name, add the NETID ((1)) and the Control Point Name ((4)). Accept the other defaults

  11. Click on OK.

Step  5.

Define a local LU

  1. Right-click on the SNA Service icon and select the Insert->APPC->Local Lu option. The Local APPC LU Properties window opens.
    Local APPC LU Properties

  2. Enter the following information:

    • The LU Alias ((12)).

    • The NETID ((9)).

    • The LU Name ((11)).

  3. Select the Advanced tab.

  4. Select the Member of Default Outgoing Local APPC LU Pool option. Accept the other defaults.

  5. Click on OK.

Step  6.

Define a remote LU

  1. Right-click on SNA Services icon and select the Insert->APPC->Remote LU option. The Remote APPC Lu Properties window opens.

  2. Click on the Connection drop down box and select the appropriate connection name ((7)).

  3. Enter the partner LU name ((2)) in the LU Alias field.

  4. Enter the Network ID ((1)) in the Network Name field.

    Figure hint not displayed.
    		The other fields will be filled in by the program. If your LU alias is not the same as your LU Name, make sure you specify the LU Name in the appropriate field. The program will fill it in automatically, but it will be incorrect if the alias and the name are not the same.

  5. Click on OK.

Step  7.

Define a mode

  1. Right-click on APPC Modes folder and select the Insert->APPC->Mode Definition option. The APPC Mode Properties window opens.
    APPC Mode Properties - General

  2. Enter the Mode Name (6) in the Mode Name field.

  3. Select the Limits tab.
    APPC Mode Properties - Limits

  4. Enter appropriate numbers for the Parallel Session Limit and Minimum Contention Winner Limit fields. Your Host-Side or LAN administrator should be able to supply you with the numbers if you do not know the limits you should place here.

  5. Accept the other defaults, and click on OK.

Step  8.

Define the CPIC name properties

  1. Right-click on CPIC Symbolic Name folder icon and select the Insert->APPC->CPIC Symbolic Name option. The CPIC Name Properties window opens.
    CPIC Name Properties - General

  2. Enter the Symbolic Destination Name ((16)) in the Name field.

  3. Click on the Mode Name drop down box and select a mode name, for example, IBMRDB.

  4. Select the Partner Information tab.
    CPIC Name Properties - Partner Information

  5. In Partner TP Name box, select the SNA Service TP (in hex) radio button and enter the Service TP name ((17)), or select the Application TP radio button and enter the Application TP name ((17)).

  6. In the Partner LU Name box, select the Fully Qualified radio button.

  7. Enter the fully-qualified Partner LU Name ((1) and (2)) or alias.

  8. Click on OK.

  9. Save the configuration

    1. Select File->Save from the menu bar of the Server Manager window. The Save File window opens.

    2. Type a unique name for your configuration into the File Name field.

    3. Click on the Save push button.



Figure car not displayed.
You now need to update the DB2 directories, bind utilities and applications to the server, and test the connection.

The easiest way to do this is to use the Client Configuration Assistant (CCA). For more information on using the CCA, go to Configuring DB2 Connect to Host or AS/400 Communications Using the CCA. However, you can also perform these steps manually, as described in Step 3. Catalog the APPC or APPN Node and the sections that follow.

Configuring Microsoft SNA Client

Read this section if you have a Windows NT workstation that has DB2 Connect installed. This section provides step-by-step instructions for setting up the communications between your DB2 Connect workstation and a Windows NT workstation that has Microsoft SNA Server V4.0 (or later) installed.

Figure car not displayed.
For instructions on how to configure Microsoft SNA Server Version 4.0 for Windows NT, go to Configuring Microsoft SNA Server for Windows NT.

Figure 11 illustrates the example DB2 Connect Server scenario.

Figure 11. Indirect Connection to host or AS/400 database server via SNA Communications Gateway


DB2 Connect Server Scenario with MS SNA Server and MS SNA Client

The rest of this section assumes:

  1. The Microsoft SNA Server has already been configured for APPC communications with the host, and is enabled for ODBC and DRDA. Refer to the Microsoft SNA Server documentation for further information.

  2. Microsoft SNA Client Version 2.11 is not already installed on your DB2 Connect workstation.

To configure the Microsoft SNA client perform the following steps:

Step 1. Obtain Required Information

For your Microsoft SNA client software to function properly you must have access to a properly configured Microsoft SNA Server. Request that your SNA Server administrator:

Step  1.

Obtain the proper license for you to use Microsoft SNA Client on your workstation.

Step  2.

Define a user ID and password for you on the SNA Server domain.

Step  3.

Define connections to the host and AS/400 databases that you need to access, as described in Configuring Microsoft SNA Server for Windows NT.

Step  4.

Provide you with the symbolic destination name ((16)), database name ((5)), and user account to use for each database connection defined in the previous step.

If you plan to change host passwords, the SNA administrator will also need to provide you with symbolic destination names for password management tasks on each host.

Step  5.

Provide you with the Microsoft SNA Server domain name and the protocol used for communicating with the SNA server (TCP/IP, NetBEUI, IPX/SPX).

Step 2. Install the Microsoft SNA Client on the DB2 Connect Workstation

  1. Obtain the Microsoft SNA Client software, and follow its instructions to start the installation program.

  2. Follow the instructions on the screen to complete the installation. Choose your SNA Server domain name and communication protocol according to the instructions provided by your SNA Server administrator.

  3. When you reach the Optional Components window, deselect Install ODBC/DRDA driver so that it will not be installed.

  4. Complete the installation.

Step 3. Install DB2 Connect for Windows

Step  1.

Install DB2 Connect.

Step  2.

Open the DB2 Folder, and click on the Client Configuration Assistant to start the configuration dialog.

Step  3.

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

Step  4.

You need to provide the following information:

__  a.

The Symbolic destination name ((16)) defined at the Microsoft SNA Server for the Partner LU ((2)) of the target host or AS/400 database server.

__  b.

The real database name ((5)).



Figure car not displayed.
You now need to update the DB2 directories, bind utilities and applications to the server, and test the connection.

The easiest way to do this is to use the Client Configuration Assistant (CCA). For more information on using the CCA, go to Configuring DB2 Connect to Host or AS/400 Communications Using the CCA. However, you can also perform these steps manually, as described in Step 3. Catalog the APPC or APPN Node and the sections that follow.

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]