MQ input stgae Transactional processing

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
bman
Participant
Posts: 33
Joined: Wed Oct 10, 2007 5:42 pm

MQ input stgae Transactional processing

Post by bman »

Hi,

I have a Job which reads from an MQ does transformation and then send it over webservice. I wanted to make the job transactional so that incase there is a failure in job, job gets aborted and the message is rolled back to the queue so that I can process it again.

I thought it was working fine for me but now realised that it is not :( . As per the director log, the transaction committed in the begining itself and it never get rolled back if the jo get abroted ?

I have set the MQ stage parameters as,
waittime=-1
Messagequantity=-1
Endof data message type=9999
Transaction recordcount=1
Message read mode=delete(Under Transaction)
Endof wave=After
End of data=Yes
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

The transaction with wave processing will only work if there is another MQ writer that closes the transaction.
Post Reply