IBM Books

Quick Beginnings

Fill in the Worksheet

Before you configure the DB2 Connect workstation, have your host-side administrator and LAN administrator fill in copies of the worksheets that follow for each host to which you want to connect:

To help you fill in the worksheets, Figure 9 illustrates a sample network that has DB2 Connect running on an OS/2 system and uses APPC to connect to DB2 for OS/390. The values shown in this diagram correspond to the Sample Value entries in the worksheet.

After you fill in the Your Value entries, you can use the worksheet to configure IBM Communications Server. As you configure Communications Server, replace the sample values that appear in the configuration instructions with your values from the worksheet. Use the boxed numbers (1) to relate the configuration instructions to the worksheet values.

In the configuration instructions, the (*) symbol denotes entries that need to be changed but do not have a representation on the worksheet.

Figure 9. Configuration on the DRDA Server and DB2 Connect Workstation


* Figure SQLC2COR not displayed.



Table 11. Worksheet for Planning OS/390, MVS, VM, or VSE Host Connections
Ref. CS/2 Name VTAM Name Sample Value Your Value
Network Elements at the Host
(1) Host Name Network name SPIFNET
(2) Partner LU Name Application Name NYM2DB2
(3) Network ID
SPIFNET
(4) Partner Node Name SSCP Name NYX
(5) Database name

OS/390 or MVS:
Location Name

VM/VSE:
RDB_Name

NEW_YORK3
(6) Mode Name
IBMRDB
Network Connection Information
(7) Connection name (Link name)
LINKHOST
(8) LAN destination address
400009451902
Network Elements at the DB2 Connect Workstation
(9) Network ID or C&SM LAN ID
SPIFNET
(10) Local Node name or Local PU Name
NYX1
(11) (Local) LU name
NYX1GW01
(12) (Local LU) alias
NYX1GW01
(13) Local Node or Node ID ID BLK 05D
(14) ID NUM 27509
(15) Mode name
IBMRDB
(16) Symbolic Destination name
DB2CPIC
(17) (Remote) Transaction program (TP) name
X'07F6C4C2' (or RDB_NAME for DB2 for VSE & VM) (or DB2DRDA for DB2 for MVS or OS/390)
DB2 Directory Entries (at the DB2 Connect workstation)
(18) Node name
db2node
(19) Security
program
(20) Database name
db2db
(21) Database alias
nyc3

Notes:

  1. The Local LU NYX1GW01 should be the LU for the SPM. If you use the SPM with this LU, you cannot use this LU to be the Control Point LU.

  2. For a connection to an OS/390, MVS, VSE, or VM system, you must know the local node name of your machine. You can find this by reviewing the Local Node Characteristics specification in your existing Communications Server configuration.


Table 12. Worksheet for Planning OS/400 Connections
Ref. CS/2 Name Network Name Sample Value Your Value
Network Elements at the Host
(1) Host name Local Network ID SPIFNET
(2) Partner LU Name Application Name NYM2DB2
(3) Network ID
SPIFNET
(4) Partner Node name Local CP Name SYD2101A
(5) Database name Relational Database Name NEW_YORK3
(6) Link Name or Mode Name
IBMRDB
Network Connection Information
(7) Connection name (Link name)
LINKHOST
(8) Remote Network address Local Adapter Address 400009451902
Network Elements at the DB2 Connect Workstation
(9) Network ID or C&SM LAN ID
SPIFNET
(10) Local Node Name or Local PU Name
NYX1
(11) (Local) LU name
NYX1GW01
(12) (Local LU) alias
NYX1GW01
(13) Local Node or Node ID ID BLK 05D
(14) ID NUM 27509
(15) Mode name
IBMRDB
(16) Symbolic Destination name
DB2CPIC
(17) (Remote) Transaction program (TP) name
X'07F6C4C2'
DB2 Directory Entries (at the DB2 Connect workstation)
(19) Node name
db2node
(19) Security
program
(20) Database name
db2db
(21) Database alias
nyc3
Note:You can determine some of the above values by running commands at the DB2 for AS/400 system:
  • To find the values for (1), (known at the OS/400 as the local network ID), and for (4), (the local control point name), enter: DSPNETA
  • To find the value for (8), (known at the OS/400 as the local adapter address), enter: WRKLIND *TRLAN

    Next, enter option 5 (Display) at the _ when prompted: 

       Opt   Line      Type     Text
    _    TRNLINE   *TRLAN

    In the screen that appears one of the lines will be similar to this: 

       Local adapter address ........:   400009451902
  • To generate a list of mode names for (15), enter: WRKMODD
  • To find the value for (5), (known at the OS/400 as the relational database name), enter: DSPRDBDIRE

    Use the RDB name associated with the entry containing *LOCAL in the Remote Location column. If no *LOCAL entry exists, either have one created or use the Current System Name displayed when you run the DSPNETA command. If the user profile under which the initial connect is made has authority to run the ADDRBDIRE command, the *LOCAL entry will be created automatically using that user profile's name on the connect attempt.

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

[ DB2 List of Books | Search the DB2 Books ]