MQ Job

svga · Post by **svga** » Tue Nov 29, 2011 10:35 am

Hi,

I have a requirement where I always need to listen to the MQ queue and write the message to the sequencial file as soon as it's arrive in the queue.

I set the Message quantity option to -1 in order to make my job always in running state. When the message arrives in the queue, I see in designer that message is getting written to file but when I actually looking at the file, I don't see any records in it.

Can anyone please help me on this issue??

chulett · Post by **chulett** » Tue Nov 29, 2011 11:49 am

Unsure of the answer but the issue is the write buffers, they only get flushed to disk periodically and only for certain when the job ends and the file is "closed".

eostic · Post by **eostic** » Tue Nov 29, 2011 1:25 pm

Exactly. The job never is "finished" when running in that fashion..instead, target an rdbms table that supports commit=1, and then get your data from there as you wish.

Ernie