topic Re: Integration with Websphere MQ in SAS Programming

Integration with Websphere MQ

deleted_user — Mon, 15 Sep 2008 15:50:59 GMT

Hi,
We need some urgent help in configuring Message Queue Polling from the Object Spawner.
We are using the Websphere MQ. Scenario : When a message arrives in a WebSphere MQ Queue a SAS ETL Job needs to be triggered.
This SAS ETL Job will read the message and process it.
Above mentioned scenario is mentioned at "http://support.sas.com/rnd/itech/doc9/dev_guide/messageq/sasqsid.html"
But it is not clear how to do it.
Can any one suggest how to accomplish such a scenario, or give an alternative suggestion.

Thankyou for your earliest attention.

Regards,

Kapil

Re: Integration with Websphere MQ

sbb — Mon, 15 Sep 2008 16:35:28 GMT

A search of the SAS support website http://support.sas.com/ revealed this technical reference on your topic/question:

Configuring WebSphere MQ to Trigger SAS: An Example
http://support.sas.com/rnd/itech/doc9/dev_guide/messageq/trigger.html

Scott Barry
SBBWorks, Inc.

Re: Integration with Websphere MQ

deleted_user — Tue, 16 Sep 2008 03:39:22 GMT

Hi Scott,
I have gone through this link also. I tried out the configuration, but the main issue is how to configure which job to trigger when a message arrives in a queue. I am using Windows OS for SAS server as well as for MQ server.
Using the method given in the link when I send a message to the transmission queue, The trigger manager gives an error that the TMC command is not recognized. I used runmqtmc -m QMSAS -q QSAS to start the trigger monitor (I am using MQ Client that's why i am using runmqtmc and not runmqtrm). The trigger monitor stars without any problem but when i send a message the trigger message is printed on command prompt : "TMC 2QSAS PROCESSOBJECTSAS QMSAS "
TMC is not recognized as an internal or external command, operable program or a batch file.

The issue remains (for any approach) where to configure the name of the job which is to be triggered.

Can you suggest any thing for the same.

Thank You,
Kapil.

Re: Integration with Websphere MQ

deleted_user — Tue, 16 Sep 2008 04:57:39 GMT

Hi Scott,
Also i would like to ask does the triggering of SAS ETL Job from MQ work in Enterprise edition of SAS Server only. I am working on Data Integration SAS server (Which is not an Enterprise Edition).

Thank You,
Kapil.

Re: Integration with Websphere MQ

LinusH — Tue, 16 Sep 2008 08:11:03 GMT

I don't think that there is any limitation with reading queues with ordinary DI Server license. About your problem, it seems something you might want to open a track to Sas tech support.

Regards,
Linus