MQ connector stage - composite messages and sequence number
Posted: Wed Sep 05, 2012 8:51 am
Hi,
We send MQ messages. The receiving system has limitation on the size of MQ message to receive, so if the message size is huge then we need to break messages and send them.
The file sent contains header(1st record), data records and trailer(last record). If the message has to be broken because of size then we need to still send the messages as belonging to a single group and sequence number should increment for each message.
I have tried segmented message option and also row buffer count property to indicate the number of rows to go into a composite message. But the sequence number is constant for all these messages.
I can before-hand split the file into required subsets and then assign the calculated sequence number. But if the messages are sent as individual messages and because of some error it delivers only few messages then the receiving team will have difficultly knowing if they will receive next messages or not. Please suggest if there is a better solution or any property settings in connector which can help.
We send MQ messages. The receiving system has limitation on the size of MQ message to receive, so if the message size is huge then we need to break messages and send them.
The file sent contains header(1st record), data records and trailer(last record). If the message has to be broken because of size then we need to still send the messages as belonging to a single group and sequence number should increment for each message.
I have tried segmented message option and also row buffer count property to indicate the number of rows to go into a composite message. But the sequence number is constant for all these messages.
I can before-hand split the file into required subsets and then assign the calculated sequence number. But if the messages are sent as individual messages and because of some error it delivers only few messages then the receiving team will have difficultly knowing if they will receive next messages or not. Please suggest if there is a better solution or any property settings in connector which can help.