more than 10k records from MQ at a time

harryhome · Post by **harryhome** » Thu Nov 16, 2006 6:18 am

Hi

The DS version we are using is 7.5 and it is an Enterprise Edition.

The problem we are facing is :
we are fetching records from MQ Stage in a server job.
when on the queue there are more than 10000 records, the job aborts giving an FATAL error -
SrcMQREQMsg..xfm_Rm_CntrlM: Failed to get message from the queue. Reason code 2024.

Do we need to set any option explicitly do avoid this?
And so that we can run more than 10k records at a time from the MQ stage?

Krazykoolrohit · Post by **Krazykoolrohit** » Thu Nov 16, 2006 9:05 am

There is nothing much datastage can do for you. Ask your mainframe admin about this reason code. He may have a better explanation for you.

Datastage will not give a database reason code when it stops/aborts. It just uses the queue to run your query and displays the records database sends it. In case your query aborts at database side, Datastage just fetches the message and shows it to you.

You see, Datastage is very smart. it never takes the blame onto itself

kaps · Post by **kaps** » Thu Nov 16, 2006 1:08 pm

Check the maximum limit of the messages which the queue can hold.
Your queue must have filled up. Either you need to increase the queue size or delete the messages as soon as you read and stores somewhere.

Thanks

harryhome · Post by **harryhome** » Sat Nov 18, 2006 7:12 am

Hi All

Thanks for the reply.

I have QMANGER to which i have admin access , so i want to know that where are these parameter 's like queue length are present in QMANGER(Its a unix box ) . i was not able to find it

plz help on same