| Author |
Message
|
| BBM |
 Posted: Tue May 22, 2007 1:50 am Post subject: Multiple messages in one transaction? |
 |
|
Master
Joined: 10 Nov 2005
Posts: 217
Location: London, UK
|
Hi,
I have a question on the dev side. Is it possible to batch messages together in one transaction.
We're currently using the v6.0 extended transactional client to pull messages from our v.6.2.1 queue manager and we'd like to speed up the process. Our developers are asking whether its possible to batch messages so they do not expend processing in opening up a transaction for every single message.
Any help, gratefully received.
cheers
BBM |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Tue May 22, 2007 2:14 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
It's up to the programmers to decide when and how to issue COMMIT.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| BBM |
| Posted: Tue May 22, 2007 2:18 am Post subject: |
|
|
Master
Joined: 10 Nov 2005
Posts: 217
Location: London, UK
|
Hi,
Thanks for that. Didn't realise it was that simple. Is there any limit to how many messages can be batched together in this way? Apologies if this is in the application programming guide but I couldn't find anything along these lines.
Cheers
BBM |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Tue May 22, 2007 2:33 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
If you run out of space in your active logs, the transaction gets rolled back.
More than 1, less than 100 is a good rule.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| Gaya3 |
| Posted: Tue May 22, 2007 2:34 am Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
Hi
You can think of that, its in APG, You will get something called sync points
Thanks and Regards
Gayathri
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| BBM |
| Posted: Tue May 22, 2007 2:47 am Post subject: |
|
|
Master
Joined: 10 Nov 2005
Posts: 217
Location: London, UK
|
Great - thanks - just found it in APG - will check out MAXUSMSGS setting.
Cheers!
BBM |
|
| Back to top |
|
|
| zpat |
| Posted: Tue May 22, 2007 2:50 am Post subject: |
|
|
Jedi Council
Joined: 19 May 2001
Posts: 5866
Location: UK
|
| IBM recommend no more than about 50 messages in one UOW for performance reasons. |
|
| Back to top |
|
|
|
|
