Problem solve Get help with specific problems with your technologies, process and projects.

Using Transparent Gateway to connect Oracle and DB2

I have one DB2 database and I am using an Oracle databse for my application. Now I want to call a DB2 stored procedure from my Oracle stored procedure. Could you please help me solve the problem. Or can you guide me on how to connect to DB2 database from Oracle environment either by creating a DBlink or by Transparent Oracle gateways? But I need to install the gateway for DB2 on my Oracle databse server. Where can I get the download of Oracle Transparent Gateway for DB2?
The Transparent Gateway software is on your Oracle installation media. If you don't have that, then you can download a copy of Oracle from Technet. In Oracle9i, Transparent Gateways was renamed as Heterogenous Services. You can find detailed information on how to set up a gateway to your DB2 database in the Oracle9i Heterogeneous Connectivity Administrator's Guide.
This was last published in November 2003

Dig Deeper on Oracle database design and architecture



Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.