IBM GC09-2830-00 Example Worksheet, To obtain the hosts IP address „TCP-9…, enter at the host

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	TCPIP	TCPIP
	(must be 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. Con®guring Host and AS/400 Databases for DB2 Connect 49