My question is mostly about the concept of LCR (logical change recortds in Oracle Streams)
I want to extract any DML script which has been applied to one specific table, but i don't want to apply this DML anywhere , I just want to send it over by AQ in oracle and then
the MQ queues in IBM will recieve it.
I don't know what the Mainframe guys are going to do with it but my task is to just send them the script?
Do you think it's possible using the LCRs?
Thanks in advance for comments!
I had implemented such a setup few months back and it works fine except for some performance issues.
you'll need to implement oracle streams and oracle messaging gateway for this propagation.
below mentioned are the generalized steps:
>>capture changes from redo log for the table by creating a capture process.
>>store these messages in the staging area of advanced queues, which in turn are queues themselves.
>>use apply process to enqueue these messages onto messaging gateway queue.
>>the messages can be transported to Websphere MQ by creating propagation jobs, foreign queue links, messaging gateway agents etc.
you can figure out the basic details using the link mentioned below.