| Author |
Message
|
| steiner |
 Posted: Wed Jul 12, 2006 4:35 am Post subject: How can I transfert in a queue more than 20000 messages |
 |
|
Voyager
Joined: 07 Mar 2003
Posts: 89
|
Hello,
I have a queue with messages that contents more than 20000 records (25000 records).
My queue can only transfert messages with 20000 records.
My question is : is there a parameter to be modify to available that 25000 records can be transfered.
Features:
MQSeries Server 5.3 CSD 05
Server HP-UX 11i
Thanks a lot. |
|
| Back to top |
|
 |
| Vitor |
| Posted: Wed Jul 12, 2006 4:41 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
Do you mean that each message contains 20000 records and needs to contain 25000? If so, your design's a little odd (forgive the impertenance) and you can increase the MAXLENGTH up to the platform limit - probably 100 Mb.
If you mean it can only hold 20000 messages, then check out the MAXDEPTH parameter on the queue.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| steiner |
| Posted: Wed Jul 12, 2006 5:07 am Post subject: |
|
|
Voyager
Joined: 07 Mar 2003
Posts: 89
|
Hello,
yes i mean now when messages contain > 20000 records it cannot be transfered because there is a limit parameter somewhere. So to transfert these messages i must cut the file in two others files and recover the header to make the transfert, but there is a lot of to do.
So if you can explain me where is that parameter and how to make the modification (on the queue or channel) to can transfert messages with > 20000 records (i think today it's 25000 records).
Thanks a lot for your help |
|
| Back to top |
|
|
| wschutz |
| Posted: Wed Jul 12, 2006 5:38 am Post subject: |
|
|
Jedi Knight
Joined: 02 Jun 2005
Posts: 3316
Location: IBM (retired)
|
Well, I would assume somewhere a program is getting: MQRC_Q_FULL (2053). Its either a queue your program is putting to directly or a transmission queue. So you need to use the MQ explorer to see which queue has MAXDEPTH set to 20000 and increase that parameter.
_________________
-wayne |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed Jul 12, 2006 5:55 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
Okay,
To settle the point of the problem can you confirm if you're getting a 2053 (queue full) or a 2030/2031 (Message too big).
If it's a 2053 then do as wschutz and I have suggested and increase MAXDEPTH. If it's 2030/2031 increase the relevent maximum message lengths as I suggested.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| steiner |
| Posted: Thu Jul 13, 2006 1:31 am Post subject: |
|
|
Voyager
Joined: 07 Mar 2003
Posts: 89
|
Okay,
I think also that this parameter must be modify.
But the error that occured was :
MQS Error occured on SEND - mqs-reason-code (2024)
MQS-PUT ended
So I have modified the Parameter MAXDEPTH on the Transmission Queue (100000 to 270000) , and I'm waiting for a test.
Do you another Idea about that error.
Thanks, bye |
|
| Back to top |
|
|
| Mr Butcher |
| Posted: Thu Jul 13, 2006 1:41 am Post subject: |
|
|
Padawan
Joined: 23 May 2005
Posts: 1716
|
if you have a returncode, the fist thing you should do is to look into the messages and codes!!!
| Quote: |
2024 X'07E8' MQRC_SYNCPOINT_LIMIT_REACHED
An MQGET, MQPUT, or MQPUT1 call failed because it would have caused the number of uncommitted messages in the current unit of work to exceed the limit defined for the queue manager (see the MaxUncommittedMsgs queue-manager attribute). |
(there is more information in the msg&codes, i just quoted the beginning
_________________
Regards, Butcher |
|
| Back to top |
|
|
| Vitor |
| Posted: Thu Jul 13, 2006 1:45 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| Mr Butcher wrote: |
if you have a returncode, the first thing you should do is to look into the messages and codes!!!
|
Absolutely! In this case, it would have provided an important clue that would have saved you some time.... 
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
|
|
