Before you configure the DB2 Connect workstation, have your host-side administrator and LAN administrator fill in copies of the following worksheet for each host to which you want to connect (see Table 13).
To help you fill in the worksheets, Figure 10 illustrates a sample network that has DB2 Connect using 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 for Windows NT. As you perform the configuration, 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.
Figure 10. Configuration on the DRDA Server and DB2 Connect Workstation
![]() |
Figure 10 illustrates the correspondences between information specified on the DRDA server system, information specified in Communications Server, and information specified in DB2 directories. The values shown in the diagram are the example values used in the instructions in this chapter.
Table 13. Worksheet for Planning OS/390, MVS, VM, VSE, or OS/400 Connections
Ref. | SNA Server Admin 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) | Control Point Name |
| NYX |
|
(5) | Database name |
| NEW_YORK3 |
|
(6) | Mode Name |
| IBMRDB |
|
(7) | Link Station Name |
| LINKHOST |
|
Network Connection Information | ||||
(8) | Destination address |
| 400009451902 |
|
Network Elements at the DB2 Connect Workstation | ||||
(9) | Network Name |
| SPIFNET |
|
(10) | Local Control Point Name |
| NYX1 |
|
(11) | Local LU name |
| NYX1GW01 |
|
(12) | Local LU alias |
| NYX1GW01 |
|
(13) | Local Node ID | Block ID | 05D |
|
(14) | Physical Unit ID | 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 OS/390 or DB2 for MVS) |
|
DB2 Directory Entries (at the DB2 Connect workstation) | ||||
(18) | Node name |
| db2node |
|
(19) | Security |
| Program |
|
(20) | Database name |
| db2db |
|
(21) | Database alias |
| nyc3 |
|