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
MQ Connector
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
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
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
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)
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)