Reading MQ messages in MQHRF2 message format in DS

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
ds_infy
Premium Member
Premium Member
Posts: 59
Joined: Tue Jun 09, 2009 4:17 am
Location: India

Reading MQ messages in MQHRF2 message format in DS

Post by ds_infy »

Hello Experts,

Can we read MQHRF2 message format MQ messages in Datastage?

Currently the jobs are failing with a Fatal Message:

"The WebSphere MQ plug-in is unable to process non-string formatted messages."

Is there a patch/ admin variable that will enable DS to read the MQHRF2 messages?

Please let me know.

Regards,
Vijay
eostic
Premium Member
Premium Member
Posts: 3838
Joined: Mon Oct 17, 2005 9:34 am

Post by eostic »

It's been too long since I've looked at this issue in a release 7 environment to remember......but the release 8 MQ Connector, if you have access to release 8 or are making plans for it, provides specific support for these types of messages.

Ernie
Ernie Ostic

blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
ds_infy
Premium Member
Premium Member
Posts: 59
Joined: Tue Jun 09, 2009 4:17 am
Location: India

Solution

Post by ds_infy »

In the MQStage, Under Tab "Output", and in "Message Filtering Options",
Check "Apply Filtering" and in the "Message Format" text box, you can add the type of messageformat eg.MQSTR or MQRFH2. This will enable the MQ stage to read XML messages of different messageFormats.

Incase you have multiple message Formats you need to have these messageFormats mentioned as a comma seperated and it should work for all messageFormats in the "MessageFormat" textbox.

Kindly Note, that though the MQ stage successully passes diff. messageFormats if you are using a XML stage it fails. So you need to either strip off the messageHeader or have the source send messages in the MQSTR format.
prasson_ibm
Premium Member
Premium Member
Posts: 536
Joined: Thu Oct 11, 2007 1:48 am
Location: Bangalore

Post by prasson_ibm »

Can you please help us how can we read MQRFH2 message body without header using MQ connector stage.
Post Reply