I had to copy some data into Oracle recently that was hosted at IBM on DB2
(naturally). The only connectivity they would allow was via JDBC but it
actually worked rather well. The most difficult bit was having to install
the rather fat DB2 client on the box I was running the process from.
Ian
I am study DB2 on mainframe to update tables on
ORACLE (UNIX). The update must be real time and 2PC.
I know ORACLE has "Transparant Gateway" to do it, but
it is tooooo expensive (95K). I am look for cheaper
solution like ODBC or MQ.
My question are:
- Any one use ODBC update from DB2 (mainframe) to
ORACLE?
- is it stable and good performance?
- Anyone use MQ (message Queue) update from DB2 to
ORACLE?
- any other solution?
Thanks.
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!
http://promotions.yahoo.com/new_mail
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at
http://www.freelists.org/archives/oracle-l/
FAQ is at
http://www.freelists.org/help/fom-serve/cache/1.html
This email has been scanned by the MessageLabs Email Security System.
For more information please visit
http://www.messagelabs.com/email
For the latest data on the economy and society
consult National Statistics at http://www.statistics.gov.uk
Please Note: Incoming and outgoing email messages
are routinely monitored for compliance with our policy
on the use of electronic communications
Legal Disclaimer : Any views expressed by
the sender of this message are not necessarily
those of the Office for National Statistics
This email has been scanned by the MessageLabs Email Security System.
For more information please visit
http://www.messagelabs.com/email
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at
http://www.freelists.org/archives/oracle-l/
FAQ is at
http://www.freelists.org/help/fom-serve/cache/1.html
Received on Wed Jul 21 2004 - 02:52:03 CDT
