IBM GC09-2830-00 User Manual

Page 60

Advertising
background image

Collecting Information

Before you can use DB2 Connect over a TCP/IP connection, you must collect
information about both the host database server and the DB2 Connect
workstation. For each host server that you are connecting to via TCP/IP, you
must have the following information:
v The location of the TCP/IP services file at the DB2 Connect workstation:

– On a UNIX system, the location of this file is usually /etc/services.
– On OS/2 Warp Version 4 the location of this file is determined by the

ETC environment variable.

– On Windows NT, the location of this file is <NT install

directory>\system32\drivers\etc\services.

v The location of the TCP/IP hosts file at the DB2 Connect workstation:

– On a UNIX system, the location of this file is usually /etc/hosts.
– On OS/2 Warp Version 4, the location of this file is usually

\mptn\etc\hosts.

– On Windows NT, the location of this file is usually <NT install

path>\system32\drivers\etc\hosts.

You may use a Domain Name Server to avoid maintaining this file on
multiple systems.

v The locations of the equivalent files at the target DB2 Universal Database

for OS/390 host.

v The TCP/IP port number defined to DB2 Universal Database for OS/390.

(Note that the associated service name information is not exchanged between
the DB2 Connect workstation and DB2 Universal Database for OS/390).
Port number 446 has been registered as the default for communication from
a DB2 Connect workstation.

v The TCP/IP addresses and hostnames for both the host and the DB2

Connect workstation.

v The LOCATION NAME of the DB2 for OS/390 database server
v The user ID and password to be used when issuing CONNECT requests for

the database at the host.

Refer to your local network administrator and your DB2 for OS/390
administrator for help getting this information. Use one copy of the example
work sheet, Table 3 on page 49, to plan each TCP/IP connection between DB2
Connect and a host database server.

48

Quick Beginnings

Advertising