Before you configure the system for DB2 Connect, have your host-side administrator and LAN administrator fill in copies of the following worksheet for each host to which you wish to connect.
To help you fill in the worksheet, Figure 13 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 Microsoft SNA Server. As you configure Microsoft SNA Server, replace the sample values that appear in the configuration instructions with your values from the worksheet. Use the boxed numbers (eg. (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 17. 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 | NETID | SPIFNET |
|
| (2) | Remote LU Name | APPL | 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) | NETID |
| SPIFNET |
|
| (10) | Local Control Point Name | PU Definition | NYX1 |
|
| (11) | (Local) LU name | LU Definition | NYX1GW01 |
|
| (12) | (Local) LU alias | Modeent | 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 VM, AXE transaction name for VSE, or DB2DRDA 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 |
|
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.