Any stage to read or write OAG message

gowrishankar_h · Post by **gowrishankar_h** » Sat Sep 07, 2013 12:59 pm

Hi,

Its there any stage to read or write OAG message?.I need to read the mainframe file from cff stage and do required transformation and compose OAG message and write it to a queue.

Its better to use MQ connector to write in queue or to use unix scriipt to write in queue..Which will be better and why?

Thanks,
Gowri

ray.wurlod · Post by **ray.wurlod** » Sat Sep 07, 2013 3:44 pm

Ordinarily OAG messages travel as XML documents, so the XML stage should be able to handle them if you have the schema available.

You could, of course, create your own custom stage type.

You might find this developerWorks article on the OAG Integration Specification interesting, even though it does not talk about DataStage implementation.

prasson_ibm · Post by **prasson_ibm** » Sat Sep 07, 2013 5:06 pm

Hi ,
Its good to use mq connector stage because it has useful supports like mq dynnamic queue, transmission queue,shared clusted queue. It can also have standard reject link.

gowrishankar_h · Post by **gowrishankar_h** » Mon Sep 30, 2013 8:46 am

Will the Mq connector will run in parallel and unix script will run on header note...so it will be good performance if we use Mq connector...am i right..

gowrishankar_h · Post by **gowrishankar_h** » Tue Oct 01, 2013 8:46 am

expert please let me know will Mq connector will run only in sequential or it will run in parellel also?

eostic · Post by **eostic** » Tue Oct 01, 2013 11:47 am

Performance is not generally a reason to choose the MQ Connector --- the environment is. If you are receiving the messages via MQ, then great --- use the MQ Connector --- it will read your incoming messages as soon as they arrive...and that would be faster than using some other utility to write the messages from MQ to disk, and then use DataStage.

...but if you aren't receiving the messages via MQ, then it is a moot question.

Exactly how are the messages arriving?

Ernie

gowrishankar_h · Post by **gowrishankar_h** » Thu Oct 03, 2013 7:23 am

eostic wrote:Performance is not generally a reason to choose the MQ Connector --- the environment is. If you are receiving the messages via MQ, then great --- use the MQ Connector --- it will read your incoming ...

Thanks...but i want to know Mq connector will do parellel loading when queue is used as target.

eostic · Post by **eostic** » Thu Oct 03, 2013 10:46 am

I've never tried "writing" with a multi-node config and allowing multiple processes at the target MQ connector, but can't think of any reason why it wouldnt work. Each instance of the operator would have its own process and its own connection to the same queue, just as if you wrote separate multiple jobs to do the same thing. Just be sure that your messages are allowed to be written in any order. In may situations, preservation of order is required, thus requiring that the Connector be run in Sequential mode.

Ernie