Filter
Top Products
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