MQ Connector

kumar_j12 · Post by **kumar_j12** » Mon Aug 25, 2014 9:09 am

Hi,

I have requirement to Read messages from source MQ message queue and copy to target MQ message queue.
I have to delete the same source MQ messages after it got committed to the target queue.

May I know the possible ways to fulfill this requirement

ray.wurlod · Post by **ray.wurlod** » Mon Aug 25, 2014 7:03 pm

Destructive read is the default mode of operation. If you need to you can move each message to a work queue pending the successful commit on the actual target queue, to give yourself a retry capability.

kumar_j12 · Post by **kumar_j12** » Tue Aug 26, 2014 7:11 am

Hi ray,
Scenario 1:I tried keeping the delete(under transaction) which is a default option and try to abort the job to see how the source is impacted and the result is I see source message queue got deleted

Scenario 2:I tried putting the Keep option as read mode and loaded into target MQ .I have another job to delete the same message queue but it deletes all the messages which are currently in source.this way I will be loosing the messages got added recently(apart from which copied in previous job)

Scenario 3:I tried the move to work queue option and instead of removing from work queue once it got commited in target its accumulating in work queue resulting the duplicate messages in target & work queue

May I know the best scenario which can full fill my requirement
What should be the properties I should put in both source & target MQ Connector.

Appreciate if you can provide me with some solution

chulett · Post by **chulett** » Tue Aug 26, 2014 2:07 pm

You could try doing an exact search for "work queue" here and then go through the other discussions on this topic, see if any of them help.

kumar_j12 · Post by **kumar_j12** » Tue Aug 26, 2014 2:47 pm

Does Distributed transaction stage as target stage connecting to MQ Connector solves the problem of delete under transaction once it commits at target queue

MQ Connector stage ----> Distributed transaction with the option mq connector

kumar_j12 · Post by **kumar_j12** » Thu Aug 28, 2014 5:29 am

I have a job which takes MQ Connector as source and Distributed Transaction stage as target stage with (MQ Connector option).
I am using datastage 8.7 version
I am getting the following error message when I try to run the job

Distributed_Transaction_29: System call dlopen() failed with OS error 2 (No such file or directory) (CC_WSMQUtil::resolveMqiMethodPointers(), file CC_WSMQUtil.cpp, line 350)