| Author |
Message
|
| jeevan |
 Posted: Sat Nov 11, 2006 5:12 am Post subject: Testing time performance in MQ application |
 |
|
Grand Master
Joined: 12 Nov 2005
Posts: 1432
|
How can we test time of message put on mq and get message from mq? My need is to test performance of mq application. Though, the performance is not only based on MQ, it is complex, but I have to find that the dealy is not caused by mq. Any suggestion.
Thanks |
|
| Back to top |
|
 |
| fjb_saper |
| Posted: Sat Nov 11, 2006 7:58 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
If you have more than one host involved you are already in a world of hurt:
Not all hosts have the same system time...
Enjoy 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Sat Nov 11, 2006 8:04 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
|
| Back to top |
|
|
| jeevan |
| Posted: Sat Nov 11, 2006 8:41 am Post subject: |
|
|
Grand Master
Joined: 12 Nov 2005
Posts: 1432
|
Definitely, it is multi-hosts application. Originating from MF and going to oracle through mq. It uses ETC. I only this much so far. I have not got the doc yet. I am goinng to client side tomorrow then only i know.
clearly.
Jeff, I am looking into this SP already. Hope this will help me. |
|
| Back to top |
|
|
| jeevan |
| Posted: Wed Nov 15, 2006 8:22 am Post subject: |
|
|
Grand Master
Joined: 12 Nov 2005
Posts: 1432
|
I am now in client side. The scenario is like this:
MF is data source. Informatica writes message to mq looking from db2 log. Our job starts when the data are in mq queue.
there are many queues in a single queue manager based on the transacton type.
Assential ( datastage) picks up message start processing and finally writes to oracle.
So our boundry is mq to oracle being datastage in between. One obvious place to look is oracle queue used in datastage in various stages for quering and inserting record for reference and finally writing the message( processed message in fact) to oracle.
the message are persistencies
and xa framework is used as this requires two phase commit.
When you think, mq might have /can cause a problem to slow down the process?
mq is used ( not sure ) as gtransaction manager.
Any thought?
thanks |
|
| Back to top |
|
|
| Nigelg |
| Posted: Wed Nov 15, 2006 11:24 pm Post subject: |
|
|
Grand Master
Joined: 02 Aug 2004
Posts: 1046
|
Easily the most likely cause of any delay is network holdups between the various machines.
Your best bet would be to write channel send and receive exits to operate on the channels to log the time msgs are sent out from and arrive back at each machine.
_________________
MQSeries.net helps those who help themselves.. |
|
| Back to top |
|
|
| jeevan |
| Posted: Thu Nov 16, 2006 8:23 am Post subject: |
|
|
Grand Master
Joined: 12 Nov 2005
Posts: 1432
|
noigelg wrote:
| Quote: |
Easily the most likely cause of any delay is network holdups between the various machines
|
But datastage, which is client, writes directly to oracle machine. There is no many machines. MQ and Datastage are in the same machine.
any furhter idea? |
|
| Back to top |
|
|
|
|
