| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Transfering Data from IMS Database to Oracle Database |
« View previous topic :: View next topic » |
| Author |
Message
|
| Beaula |
 Posted: Mon Oct 21, 2002 4:53 am Post subject: Transfering Data from IMS Database to Oracle Database |
 |
|
Apprentice
Joined: 11 Sep 2002
Posts: 39
Location: Infotech, Madhapur,India
|
My question might be silly but still................
I have a application running on RS6000 & the data entered in the application is stored onto IMS Database on RS6000. The same data has to be transferred to Oracle Database on Sun Solaris machine.
How do I start with designing the message flow ?. How to use database node here?.
Should I put the data from the application on to a queue and connect to the oracle database and insert the data using database insert node. In this case, if there the data is not entered in Oracle database, how to make sure that the data is not lost and inserted later......
Please give how to design the flow and complete the process ?. |
|
| Back to top |
|
 |
| kirani |
| Posted: Wed Oct 23, 2002 9:30 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Beaula,
Write an application program, which reads data from IMS Database and puts it on the queue in some format. Using Control Center model your messages in MRM.
Now create a message flow, which reads data from input queue and parses it using MRM message definition. You could make use of DB nodes to insert parsed data into ORACLE database. You could route failed messages to another queue so that they can be processed later. Make sure your messages are Persistent messages.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| tchagan |
| Posted: Thu Oct 24, 2002 1:17 am Post subject: |
|
|
Apprentice
Joined: 10 Feb 2002
Posts: 31
|
I think you should be asking is WMQI the correct tool to do this? Is this an online system where everytime data is entered into your IMS database it must be immediately passed to the Oracle database or is a nightly feed of data enough?
Terry |
|
| Back to top |
|
|
| Beaula |
| Posted: Thu Oct 24, 2002 4:52 am Post subject: Re: Transfering Data from IMS Database to Oracle Database |
|
|
Apprentice
Joined: 11 Sep 2002
Posts: 39
Location: Infotech, Madhapur,India
|
| Beaula wrote: |
My question might be silly but still................
I have a application running on RS6000 & the data entered in the application is stored onto IMS Database on RS6000. The same data has to be transferred to Oracle Database on Sun Solaris machine.
How do I start with designing the message flow ?. How to use database node here?.
Should I put the data from the application on to a queue and connect to the oracle database and insert the data using database insert node. In this case, if there the data is not entered in Oracle database, how to make sure that the data is not lost and inserted later......
Please give how to design the flow and complete the process ?. |
Thanks for the reply Kirani.
I wrote an application and put the messages to the queue and inserted the data to the database sucessfully. My doubt is if the data is not inserted to the database how the message is rolled back to the queue and can be inserted later. How is the ESL written for the commiting the data insert ?.
You had mentioned that if we send the failed data to the failure queue, we can use the data is again. Can you please give how this queue can again be called in the main message flow ?.......... |
|
| Back to top |
|
|
| Beaula |
| Posted: Wed Nov 06, 2002 7:09 pm Post subject: IMS Database Online system |
|
|
Apprentice
Joined: 11 Sep 2002
Posts: 39
Location: Infotech, Madhapur,India
|
| tchagan wrote: |
I think you should be asking is WMQI the correct tool to do this? Is this an online system where everytime data is entered into your IMS database it must be immediately passed to the Oracle database or is a nightly feed of data enough?
Terry |
This is an Online system where everytime the data entered into IMS database must be transferred to Oracle. From What i understood from the MQSI Documentaion is that the data entered should be put to a queue and the message flow uses the MQInput Node and the compute node extracts the data from database with the message in queue. Can we connect to the database directly without MQInput Node. ...? |
|
| 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
|
|
|
|
