Distributed Transaction Stage

padmavathi · Post by **padmavathi** » Sun Feb 19, 2012 10:26 pm

Hi,

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.

Thanks
Padma

ray.wurlod · Post by **ray.wurlod** » Sun Feb 19, 2012 11:40 pm

As far as I am aware there is no Distributed Transaction Stage in DataStage TX. Perhaps consider posting in the correct forum?

v2kmadhav · Post by **v2kmadhav** » Mon Feb 20, 2012 2:19 am

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.

padmavathi · Post by **padmavathi** » Mon Feb 20, 2012 5:35 am

Thank you. Its working fine...

chulett · Post by **chulett** » Mon Feb 20, 2012 9:26 am

Relocated. Next time please pay more attention to where you are posting.