| Author |
Message
|
| MQSIBM |
 Posted: Mon Jan 07, 2002 10:56 am Post subject: |
 |
|
Novice
Joined: 31 Oct 2001
Posts: 18
|
Hi
for a volume of 1,500,000 messages ...
what would be the ideal LogFile size and number of Log Primaryfile, Log Secondary File I should be using ?
MQ,DB2 running on Solaris environment. |
|
| Back to top |
|
 |
| bduncan |
| Posted: Mon Jan 07, 2002 1:11 pm Post subject: |
|
|
Padawan
Joined: 11 Apr 2001
Posts: 1554
Location: Silicon Valley
|
We'll probably need some more info first. I'm assuming that 1.5mil volume is a daily volume, so we still need to know what the average size of each message is going to be. Also, is the 1.5mil spread out evenly across the day, or is most of the activity in short periods (spikes)? Also, are the messages persistent or not persistent, and are you using syncpoint?
_________________
Brandon Duncan
IBM Certified MQSeries Specialist
MQSeries.net forum moderator |
|
| Back to top |
|
|
| MQSIBM |
| Posted: Mon Jan 07, 2002 8:43 pm Post subject: |
|
|
Novice
Joined: 31 Oct 2001
Posts: 18
|
Oooops ! i missed the vital info.
thanks Duncan for pointing out.
All the 1.5 million messages are sent at-once in a batch. msg size is going to be fixed but not sure about the size yet ..
my queue manager would receive messages from the Oracle database and are intended to be written to a file. The messages are going to be persistent with syncpoint.
thanks & lookin forward for ur suugestion |
|
| Back to top |
|
|
| jhalstead |
| Posted: Tue Jan 08, 2002 2:23 am Post subject: |
|
|
Master
Joined: 16 Aug 2001
Posts: 258
Location: London
|
Have you made a decision as to whether it's going to be linear or circular logging?
Jamie |
|
| Back to top |
|
|
| MQSIBM |
| Posted: Tue Jan 08, 2002 9:06 am Post subject: |
|
|
Novice
Joined: 31 Oct 2001
Posts: 18
|
Hi i missed one more point ... in my previous reply ....
besides having the queue which handles 1.5 million mesgs
i also have other queues which handle message volume ranging frm 10,000 - nearly million msgs ... some of these queues are in the same Queue manager which handles 1.5 million and some are distributed on others.... some these message volume is sent on the same day and some message volume is spread out on to different days. |
|
| Back to top |
|
|
| PeterPotkay |
| Posted: Tue Jan 08, 2002 10:46 am Post subject: |
|
|
Poobah
Joined: 15 May 2001
Posts: 7722
|
you say that you will send 1.5 million messages at once. remember that an MQ queue can only hold up to 640,000 messages at any one time, so a recieving process will have to start processing the queue right away.
_________________
Peter Potkay
Keep Calm and MQ On |
|
| Back to top |
|
|
| MQSIBM |
| Posted: Tue Jan 08, 2002 12:51 pm Post subject: |
|
|
Novice
Joined: 31 Oct 2001
Posts: 18
|
yes, Peter i have that receiving process running parallel.
but i need to know if the default log settings would be enuff for handling this huge message volume. If not what would be the settings for it. |
|
| Back to top |
|
|
|
|
