MQ Connector Payload size limit

hondaccord94 · Post by **hondaccord94** » Wed Jan 20, 2010 2:18 pm

I am using MQ Connector on DataStage 8.1 to read an xml message.

I am getting this error " WebSphere_MQ_Connector_0,0: Fatal Error: Virtual
data set.; output of "WebSphere_MQ_Connector_0": the record is too big to
fit in a block; the length requested is: 1646578, the max block length is:
131072."

Is there a parameter, I need to tweak to handle this error?

Please advise.

eostic · Post by **eostic** » Wed Jan 20, 2010 2:54 pm

Here are some things to try....

Increase the APT_DEFAULT_TRANSPORT_BLOCK_SIZE. I have had success with that when needing a larger size to support XML stages, albeit not with the MQ Connector....

Try a Server Job. It may not be what you need, but it might offer clues as to the issue, as Server sometimes is less finicky about large columns.

Ernie

hondaccord94 · Post by **hondaccord94** » Wed Jan 20, 2010 5:12 pm

Changing the variable default to 2000000 and it worked.
Thanks a lot for your suggestion.

eostic wrote:Here are some things to try....

Increase the APT_DEFAULT_TRANSPORT_BLOCK_SIZE. I have had success with that when needing a larger size to support XML stages, albeit not with the MQ Connector....

Try a Server Job. It may not be what you need, but it might offer clues as to the issue, as Server sometimes is less finicky about large columns.

Ernie