| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Transfer Data Urgent... |
« View previous topic :: View next topic » |
| Author |
Message
|
| tompagan |
 Posted: Wed Sep 11, 2002 8:53 pm Post subject: Transfer Data Urgent... |
 |
|
Newbie
Joined: 10 Sep 2002
Posts: 2
|
Hai,
Can any one tell how to transfer data in MQSI from Oracle to DB2.. what I have to do in message flow .. I have to transfer the hole data from Oracle database to DB2 database..it's urgent try to mail immediatly..
Thanks |
|
| Back to top |
|
 |
| wolstek |
| Posted: Thu Sep 12, 2002 12:11 am Post subject: |
|
|
Acolyte
Joined: 25 Jun 2001
Posts: 52
Location: Bristol, UK
|
If you mean transfer your broker/configmgr configuration from Oracle to DB2, if so have you tried exporting the configuration from Oracle, then importing into the DB2 environment
If you mean day to day running of flow, e.g flow reads from Oracle and writes to DB2, then you will need separate Datasource names or ODBC drivers each enabled for ODBC. One for your Oracle DB (say ORACDS), the other for your DB2 DB (say DB2DS).
You then need your Compute node to read from the ORACLE database specify datasource ORACDS and store in the message tree, then in a subsequent Database or DataInsert node, write to the DB2DS datasource. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
