MQ commit/backout

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
ArjunK
Participant
Posts: 30
Joined: Sun Apr 30, 2006 6:32 pm

MQ commit/backout

Post by ArjunK »

Hi,
We have a parallel job in which we are reading messages from MQ and writing to a file using the folder stage (server container).

MQ -> transformer -> folder (server container)

The Destructive read option is checked along with the Commit/backout only at the end of the job option.

Still , we seeing that if the job aborts the messages are being deleted from the queue.

We tested this manually by changing the folder permissions on the directory where datastage is writing the files. The job aborted giving error that it was not able to open the folder but the messages were also lost.


Thanks,
Arjun
ArjunK
Participant
Posts: 30
Joined: Sun Apr 30, 2006 6:32 pm

Post by ArjunK »

We have observed this issue happening only when we use a Folder Server Shared container in a parallel job.
Now we completely switched to a server job instead of using the shared container.
Post Reply