Interface DB2 to Oracle

150 pts.
Tags:
DB2
Oracle
Dear all, I  have an 02 database (Oracle database 11 and DB2). I'm using inquiry command SQL in DB2 select about 2 million records very fast but interface to ORACLE by Database gateway transaction process very slow. Please give me reccommend or doccument. Thanks for help
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Subhendu Sen
    Link here for a good info: http://help.sap.com/saphelp_erp60_sp/helpdata/en/c4/3a727e505211d189550000e829fbbd/content.htm
    140,480 pointsBadges:
    report
  • carlosdl
    Most likely any kind of bridge/adapter/connector to interconnect databases by different vendors will use an ODBC driver, which standardizes the commands that are executed from one database to the other one.

    That kind of connection is usually slower than a native vendor-specific connection.

    I would expect something like that to happen (to some degree).
    84,805 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: