MQ Message splitup

senthil_tcs · Post by **senthil_tcs** » Tue Jul 13, 2010 9:29 am

Hi,

Appreciate any help on this!

When I use a multi node configuration file in DataStage the message in MQ is getting spilited into multiple chunks depends on the no of nodes given in the config file. Is there an option wherein the message will be loaded as one single file though we use multi node configuration file.

I am able to load all the records as one single message if I use a single node configuration file.

Thanks,
Senthil Kumar

eostic · Post by **eostic** » Tue Jul 13, 2010 9:11 pm

Are you doing a destructive read? ...or are you browsing? ("keep" option)? Unlikely that it is splitting up messages, but it most certainly every node will browse the same message......

ArndW · Post by **ArndW** » Wed Jul 14, 2010 2:31 am

You can declare your MQ stage to run sequentially, that way the APT_CONFIG_FILE setting doesn't apply. Downstream you can then repartation to your heart's content.

senthil_tcs · Post by **senthil_tcs** » Wed Jul 14, 2010 3:37 am

Thanks, I had a similar thought but I didn't the execution option (Advanced tab) where we change the mode Sequential/Parallel in MQ connector. Even I have tried changing the execution mode to Sequential in transformer as we have a transformed stage before MQ connector but no luck.

Can you please help me to locate option where we can change the execution to sequential?

ArndW wrote:You can declare your MQ stage to run sequentially, that way the APT_CONFIG_FILE setting doesn't apply. Downstream you can then repartation to your heart's content. ...

senthil_tcs · Post by **senthil_tcs** » Wed Jul 14, 2010 3:39 am

Thanks, I had a similar thought but I didn't the execution option (Advanced tab) where we change the mode Sequential/Parallel in MQ connector. Even I have tried changing the execution mode to Sequential in transformer as we have a transformed stage before MQ connector but no luck.

Can you please help me to locate option where we can change the execution to sequential?

ArndW wrote:You can declare your MQ stage to run sequentially, that way the APT_CONFIG_FILE setting doesn't apply. Downstream you can then repartation to your heart's content. ...

ArndW · Post by **ArndW** » Wed Jul 14, 2010 5:52 am

In the upper left hand picture, click on the stage and not the link, then you can choose sequential execution mode.

senthil_tcs · Post by **senthil_tcs** » Wed Jul 14, 2010 2:36 pm

Excellent, thanks the content is loaded as a single message.