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 15).
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.
Table 15. 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) | Remote LU Name | Application Name | NYM2DB2 |
|
| (3) | Network ID |
| SPIFNET |
|
| (4) | Control Point Name |
| NYX |
|
| (5) | Database name |
| NEW_YORK3 |
|
| (6) | Mode Name |
| IBMRDB |
|
| (7) | Connection Name |
| LINKHOST |
|
| Network Connection Information | ||||
| (8) | Remote Network 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 | 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 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 |
|
For an OS/390, MVS, VSE, or VM connection, you need the control point name of your DB2 Connect workstation. Your network administrator can provide you with this information.
Figure 9 illustrates the correspondences between information specified on the DRDA server system, information specified in SNA Server Administration, and information specified in DB2 directories. The values shown in the diagram are the example values used in the instructions in this chapter.