IBM GC09-2830-00 User 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