How to Handle the MQ Failure

pksahu · Post by **pksahu** » Mon Oct 18, 2010 7:37 am

Hi,
I want to Handle the MQ Connector Stage sequence while the sequence abort in the middle (while reading the Message from the Queue).

Example: Suppose I have 100 messages in the queue and writing into a Dataset. If due to some reason the message queue failed after reading 50 messages, how I should handle to read the entire 100 message again so that I will get the full set of data.

Can anyone give some idea what should I follow to archive this?

Regards,
Pksahu

eostic · Post by **eostic** » Mon Oct 18, 2010 8:19 am

Well.... you probably don't want to choose a destructive read in this case. A DataSet is just a file on disk --- there is no ensured delivery for that. To be safe, "browse" your messages and don't remove them from the original queue until you are sure that things have been completed successfully on the other side.

An alternative is to look at what the Connector can do for "work queues"....put the messages into a work queue (which the Connector is able to do under "syncpoint"...meaning that they get moved with assured delivery in an MQ transaction and won't be dropped) and then delete them later from there when you have things correctly in your target, whatever that target might be.

Ernie