| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| MQ XA problem |
« View previous topic :: View next topic » |
| Author |
Message
|
| tiangl |
 Posted: Sun Apr 22, 2007 7:35 pm Post subject: MQ XA problem |
 |
|
Apprentice
Joined: 19 Nov 2004
Posts: 48
|
We used XA in MQ. when MQ started, We will do some SQL query in Oracle via XA, the sql is like below here:
select formated,globalid,branched from sys.dba_pending_transactions order by formated, globalid, branched;
but sometimes, this sql operation will be hanged,and MQ can't be started successfully.
my question is where can i find problem is , is there any log?
thanks! |
|
| Back to top |
|
 |
| tiangl |
| Posted: Mon Apr 23, 2007 9:28 pm Post subject: |
|
|
Apprentice
Joined: 19 Nov 2004
Posts: 48
|
the performance is more worse, the MQCOMMIT will spend 1-2 second. anyone have experience like this? how to slove this problem?
the time-consuming of every step is below here:
INFO20050424094753::-----begin qmgrr.begin(),4325mms
INFO20050424094753::-----end cr.open,1194mms
INFO20050424094753::-----end qServer.get,247mms
INFO20050424094753::-----end unpkg_head,72mms
INFO20050424094753::-----end insert_head,2314mms
INFO20050424094753::-----end table_insert,3546mms
INFO20050424094753::-----end table_insert,1940mms
INFO20050424094753::-----end unpkg_insert(),1356mms
INFO20050424094753::-----end db.disconnect,81mms
INFO20050424094754::-----end qmgrr.commit,921538mms
INFO20050424094754::-----begin qmgrr.begin(),4640mms
INFO20050424094754::-----end cr.open,1311mms
INFO20050424094754::-----end qServer.get,268mms
INFO20050424094754::-----end unpkg_head,71mms
INFO20050424094754::-----end insert_head,1921mms
INFO20050424094754::-----end table_insert,563mms
INFO20050424094754::-----end table_insert,3058mms
INFO20050424094754::-----end table_insert,2033mms
INFO20050424094754::-----end table_insert,9324mms
INFO20050424094754::-----end table_insert,2309mms
INFO20050424094754::-----end unpkg_insert(),1238mms
INFO20050424094754::-----end db.disconnect,67mms
INFO20050424094754::-----end qmgrr.commit,447589mms
INFO20050424094754::-----begin qmgrr.begin(),5108mms
INFO20050424094754::-----end cr.open,1299mms
INFO20050424094754::-----end qServer.get,250mms
INFO20050424094754::-----end unpkg_head,70mms
INFO20050424094754::-----end insert_head,1900mms
INFO20050424094754::-----end table_insert,3518mms
INFO20050424094754::-----end table_insert,1940mms
INFO20050424094754::-----end unpkg_insert(),1290mms
INFO20050424094754::-----end db.disconnect,64mms
INFO20050424094756::-----end qmgrr.commit,2088579mms
INFO20050424094756::-----begin qmgrr.begin(),4796mms
INFO20050424094756::-----end cr.open,1333mms
INFO20050424094756::-----end qServer.get,244mms
INFO20050424094756::-----end unpkg_head,70mms
INFO20050424094756::-----end insert_head,1775mms
INFO20050424094756::-----end table_insert,887mms
INFO20050424094756::-----end table_insert,1943mms
INFO20050424094756::-----end table_insert,458mms
INFO20050424094756::-----end unpkg_insert(),1133mms
INFO20050424094756::-----end db.disconnect,69mms
INFO20050424094758::-----end qmgrr.commit,1712160mms |
|
| Back to top |
|
|
| Vitor |
| Posted: Mon Apr 23, 2007 11:56 pm Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
What are you using as the XA coordinator?
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| tiangl |
| Posted: Tue Apr 24, 2007 12:23 am Post subject: |
|
|
Apprentice
Joined: 19 Nov 2004
Posts: 48
|
| vitor,we used MQ as XA coordinator. |
|
| Back to top |
|
|
| tiangl |
| Posted: Tue Apr 24, 2007 12:25 am Post subject: |
|
|
Apprentice
Joined: 19 Nov 2004
Posts: 48
|
| MQ version is v5.3 + csd06 , OS is redhat linux v2.6 |
|
| Back to top |
|
|
| tiangl |
| Posted: Tue Apr 24, 2007 12:28 am Post subject: |
|
|
Apprentice
Joined: 19 Nov 2004
Posts: 48
|
the application is quiet simple:
MQBEGIN
insert into Oracle_table
put msg to Queue
MQCOMMIT
there's no trigger or join on the Oracle table. just MQCOMMIT will spend much time. so weird. |
|
| Back to top |
|
|
| Vitor |
| Posted: Tue Apr 24, 2007 12:50 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
Firstly, v5.3.6 is very old and IIRC is a bit flaky on the subject of XA. You should upgrade.
Secondly, are you sure the queue manager can coordinate an external transaction rather than participate in it?
Thirdly, how have you configured the XA support in the queue manager, and what documentation reference did you use?
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| tiangl |
| Posted: Tue Apr 24, 2007 7:52 pm Post subject: |
|
|
Apprentice
Joined: 19 Nov 2004
Posts: 48
|
vitor,thank you so much!
my answer to your question:
Firstly, v5.3.6 is very old and IIRC is a bit flaky on the subject of XA. You should upgrade.
I will consider upgrade
Secondly, are you sure the queue manager can coordinate an external transaction rather than participate in it?
i'm not sure what's your mean? could you explain more? as my understanding, Queue Manager can be as coordinator to do two-phase commit.
Thirdly, how have you configured the XA support in the queue manager, and what documentation reference did you use?
here is QM.ini, you can find XA configuration:
XAResourceManager:
Name=ORACLE bsscrm
SwitchFile=/opt/mqm/bin/oraswit
XAOpenString=Oracle_XA+DB=bsscrm+Acc=P/cr232/pql2amz+SesTm=35+LogDir=/var/mqm/log_xa+SqlNet=bsscrm
XAResourceManager:
Name=ORACLE bssbill
SwitchFile=/opt/mqm/bin/oraswit
XAOpenString=Oracle_XA+DB=bssbill+Acc=P/uni23e/bss_xp1+SesTm=35+LogDir=/var/mqm/log_xa+SqlNet=bssbill
another thing is that there are more than 80 processes on this QM, every process is doing get msg and insert into oracle table,then commit. Is that possible the processes is too much on one QM? if so, how to adjust parameter?
we did a test, it spent 0.5s to commit without queue and table operation. |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed Apr 25, 2007 12:03 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| tiangl wrote: |
here is QM.ini, you can find XA configuration:
XAResourceManager:
Name=ORACLE bsscrm
SwitchFile=/opt/mqm/bin/oraswit
|
The XA resource manager is Oracle in your configuration then... 
AFAIK (and I'll stand correction on this) a queue manager can participate in an XA transaction but can't coordinate it.
Doesn't actually affect your performance problem though. I would say it's either a database issue or something with the way MQ is handing off the XA. I'd investigate the former and see if the upgrade fixes the latter (moving up from CSD 6 is a good idea even if it's not your problem in this instance).
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed Apr 25, 2007 5:05 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Under XA, queue managers can either be the TransactionManager or just a Resource Manager.
I'm not aware of any particular tuning to improve the speed of the XA logic.
You will find after you upgrade, that performance will improve on it's own - performance enhancements is one of the things that goes into maintenance and new versions.
You might also make sure that your queue manager has sufficient log size to hold the queue transactions you're making, and that it's not cycling logs. Also you can do a bunch of other kinds of tuning. Read the Performance Report Support Packs.
It might also be your database that is taking so long.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| tiangl |
| Posted: Thu Apr 26, 2007 2:25 am Post subject: |
|
|
Apprentice
Joined: 19 Nov 2004
Posts: 48
|
| thanks, vitor and jeff. when i met this situation, my first reflection is that it should be oralce problem,not mq. so today, after adjusted parameter of oracle db i/o, the performance is becoming better,but still cannot be satified by customer. they suspected that multiple processes on QM caused the performance issue. is that possible? |
|
| Back to top |
|
|
| Vitor |
| Posted: Thu Apr 26, 2007 2:28 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| tiangl wrote: |
| they suspected that multiple processes on QM caused the performance issue. is that possible? |
It's possible, as jefflowrey has said, that 5.3.6 doesn't move as fast as later versions. You may be able to tune it a bit using the documentation he references.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| tiangl |
| Posted: Sat Apr 28, 2007 9:18 pm Post subject: |
|
|
Apprentice
Joined: 19 Nov 2004
Posts: 48
|
| jeff, can i ask you question what performance report support pack you mentioned? I know where to check mq support pack,but i don't know which one you said. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
