Installing DB2 Information Integrator on a Separate Server

© 2003 International Business Machines Corporation. All rights reserved.

If you install DB2® Information Integrator™ on a different server from the Oracle server -- for instance, on host DOER (instead of THINKER where Oracle is installed) -- perform the following steps before installing DB2 Information Integrator:

1. Contact the Oracle DBA and obtain a Oracle userid, table names, and the connection information for the Oracle server. The connection information that is needed is in the Oracle server's listener configuration file (listener.ora).

   You need from that file the following items:

   • The hostname
   • The istener port (1521 is the default)
   • The Oracle server's service name or SID

2. On the DB2 Information Integrator server, install the Oracle client.
3. Configure the Oracle client to connect to the Oracle server. On Windows, there is the Oracle Net Client Configuration Assistant GUI for doing this. This creates the Oracle client configuration file (tnsnames.ora) and puts an entry into it for the Oracle server.
4. Then install DB2 Information Integrator.

Back to article

IBM, DB2, and DB2 Information Integrator are trademarks or registered trademarks of IBM Corporation in the United States, other countries, or both.

Other company, product, and service names may be trademarks or service marks of others.

IBM copyright and trademark information