Filter
Top Products
Configuring the TCP/IP Connection
Use the manual steps in this section to complete the configuration and make
the connection.
Complete the Worksheet: Complete a copy of the example worksheet for
each TCP/IP host:
1. Fill in the values to be used for the TCP/IP address and hostname of the
DB2 Universal Database for OS/390 host (items 8 and 9).
2. Fill in the values to be used for the TCP/IP address and hostname of the
DB2 Connect workstation (items 18 and 19).
3. Determine the port number or service name to be used for the connection
(items 10 and 11, or 20 and 21).
4. Determine the LOCATION NAME of the DB2 for OS/390 database server
to which you wish to connect.
5. Determine the values to be used for user ID and PASSWORD when
connecting to the host database.
Note that some additional planning considerations may apply, for example if
you are using DCE. See the DB2 Connect User’s Guide.
Update the DB2 Universal Database for OS/390 Host: At your OS/390 host:
1. Verify the host address or the host name.
2. Verify the port number or the service name.
3. Update the services file with the correct port number and service name if
necessary.
4. Update the hosts file (or the Domain Name Server used by the DB2
Universal Database for OS/390 system) with the hostname and IP address
of the DB2 Connect workstation if necessary.
5. Ensure the new definitions are active before attempting to test the
connection. Refer to your host network administrator or change control
staff if necessary.
6. Check with the DB2 Universal Database for OS/390 administrator that you
have a valid user ID, password, and database LOCATION NAME.
7. PING the DB2 Connect workstation, using the correct port number if that
option is supported by TCP/IP on the host system. For example:
ping remote_host_name -p port_number
Update the DB2 Connect Configuration: At a command line prompt, issue
the following command to update the Database Manager Configuration:
db2 update dbm config using TM_DATABASE 1st_conn
where TM_DATABASE can have one of the following settings:
50 Quick Beginnings