IBM GC09-2830-00 - Manual (Page 61)

Example Worksheet:
Table 3. Example Worksheet for Planning TCP/IP Connections to DB2 Universal
Database for OS/390
Ref. Description Sample Value Your Value
User Information
TCP-1
User Name A.D.B.User
TCP-2
Contact Info (123)-456-7890
TCP-5
User ID ADBUSER
TCP-6
Database Type db2390
TCP-7
Connection type
(must be TCPIP). TCPIP TCPIP
Network Elements at the Host
TCP-8
Host name MVSHOST
TCP-9
Host IP address 9.21.152.100
TCP-10
Service name db2inst1c
TCP-11
Port number 446
TCP-12
LOCATION NAME NEW_YORK3
TCP-13
User ID
TCP-14
Password
Network Elements at the DB2 Connect Workstation
TCP-18
Host name mcook02
TCP-19
IP address 9.21.27.179
TCP-20
Service name db2inst1c
TCP-21
Port number 446
DB2 Directory Entries (at the DB2 Connect workstation)
TCP-30
Node name MVSIPNOD
TCP-31
Database name nyc3
TCP-32
Database alias mvsipdb1
TCP-33
DCS database name nyc3
Notes:
1. To obtain the host’s IP address
TCP-9 , enter at the host:
TSO NETSTAT HOME
2. To obtain the port number
TCP-11 , look for DSNL004I in the DB2 master
address space or system log.
Chapter 5. Configuring Host and AS/400 Databases for DB2 Connect 49