MQ Series Pluggin
Posted: Fri Dec 10, 2004 10:12 am
Hello All:
I have designed a job that reads messages form the MQ Message queue and then seperates the header and data. The data which is delimited is read and parsed into a variable. That variable in which the data is parsed is broken into number of columns using row splitter then dumped into transformer since the source columns are lesser than the target columns the extra columns are set to @NULL and then all is dumped into the sequential (target) file.
Not using destructive read. Set to read.
The setting for MQ Pluggin is set as follows:
WAIT TIME = 0 (specifies no wait time to read the message)
MESSAGE LIMIT = 244,014
END OF DATA MESSAGE = 0
It reads the data in 58 minutes. I have checked my design and have no unnessary processes or files that could increase the read/write time.
But is there any way of increasing the performace and read the data in lesser time. Is there a benchmark that tells me its a good read and write time (58 Minutes)
Is there a better way...? Would appreciate a response at the earliest convenience.
Thanks in advance.
MJ
I have designed a job that reads messages form the MQ Message queue and then seperates the header and data. The data which is delimited is read and parsed into a variable. That variable in which the data is parsed is broken into number of columns using row splitter then dumped into transformer since the source columns are lesser than the target columns the extra columns are set to @NULL and then all is dumped into the sequential (target) file.
Not using destructive read. Set to read.
The setting for MQ Pluggin is set as follows:
WAIT TIME = 0 (specifies no wait time to read the message)
MESSAGE LIMIT = 244,014
END OF DATA MESSAGE = 0
It reads the data in 58 minutes. I have checked my design and have no unnessary processes or files that could increase the read/write time.
But is there any way of increasing the performace and read the data in lesser time. Is there a benchmark that tells me its a good read and write time (58 Minutes)
Is there a better way...? Would appreciate a response at the earliest convenience.
Thanks in advance.
MJ