I have requirement to keep mesages that are failed to process in queue and messages processed successfully has to load to database and should be deleted from Queue.
I am using MQ Connector as Source and Distributed transaction stage to load processed messages to DB2 table.
If I have 5 messages in Queue, irrespective of job status(out aof processed and faield message), 4 messages are loadign to Work queue. If retrigger the job , these 4 messages are processing and 3 are laoding back to Work queue.
Plese advise how to get funstionality of only failed records should be kept in work queue and processed messages have to get deleted from source and work queue.
If you read the messages as "Move to work" queue and propogate the binded MsgId to the DTS stage.. it should move only records that failed to the work queue.