| Author |
Message |
 Topic: Dead Lock on Oracle 10g |
tiangl
Replies: 1
Views: 1930
|
 Forum: General Discussion Posted: Wed Sep 05, 2007 1:33 am Subject: Dead Lock on Oracle 10g |
| we have a MQ XA program which will do some operation in Oracle. this program is working very well with Oracle 9i,but when customer upgraded their oracle to 10g, we found the deadlock will be happened ... |
| Topic: MQ XA problem |
tiangl
Replies: 12
Views: 7917
|
Forum: General IBM MQ Support Posted: Sat Apr 28, 2007 9:18 pm Subject: MQ XA problem |
| 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. |
| Topic: MQ XA problem |
tiangl
Replies: 12
Views: 7917
|
Forum: General IBM MQ Support Posted: Thu Apr 26, 2007 2:25 am Subject: MQ XA problem |
| 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 bett ... |
| Topic: MQ XA problem |
tiangl
Replies: 12
Views: 7917
|
Forum: General IBM MQ Support Posted: Tue Apr 24, 2007 7:52 pm Subject: MQ XA problem |
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 yo ... |
| Topic: MQ XA problem |
tiangl
Replies: 12
Views: 7917
|
Forum: General IBM MQ Support Posted: Tue Apr 24, 2007 12:28 am Subject: MQ XA problem |
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. |
| Topic: MQ XA problem |
tiangl
Replies: 12
Views: 7917
|
Forum: General IBM MQ Support Posted: Tue Apr 24, 2007 12:25 am Subject: MQ XA problem |
| MQ version is v5.3 + csd06 , OS is redhat linux v2.6 |
| Topic: MQ XA problem |
tiangl
Replies: 12
Views: 7917
|
Forum: General IBM MQ Support Posted: Tue Apr 24, 2007 12:23 am Subject: MQ XA problem |
| vitor,we used MQ as XA coordinator. |
| Topic: MQ XA problem |
tiangl
Replies: 12
Views: 7917
|
Forum: General IBM MQ Support Posted: Mon Apr 23, 2007 9:28 pm Subject: MQ XA problem |
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:
INFO200504240947 ... |
| Topic: MQ XA problem |
tiangl
Replies: 12
Views: 7917
|
Forum: General IBM MQ Support Posted: Sun Apr 22, 2007 7:35 pm Subject: MQ XA problem |
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, glo ... |
| Topic: problem about cobol program based on MQ V6.0 on iSeries V5R4 |
tiangl
Replies: 1
Views: 3203
|
Forum: General Discussion Posted: Tue Mar 20, 2007 1:37 am Subject: problem about cobol program based on MQ V6.0 on iSeries V5R4 |
| this problem was fixed by restore GLBLSRC save file which got from MQ v5.3 on i5OS v5.3. so problem is that MQ v6.0 on V5R4 doesn't include this file. |
| Topic: problem about cobol program based on MQ V6.0 on iSeries V5R4 |
tiangl
Replies: 1
Views: 3203
|
Forum: General Discussion Posted: Tue Mar 20, 2007 12:11 am Subject: problem about cobol program based on MQ V6.0 on iSeries V5R4 |
| after MQ v6.0 installation on V5R4, we tried to compile some MQ cobol program , but complier failed , it said "copy file QLBLSRC in *LBL could not be opened" . We did edit LIBPATH and added ... |
| Topic: JMS input node on aix |
tiangl
Replies: 6
Views: 4994
|
Forum: WebSphere Message Broker (ACE) Support Posted: Sun Mar 18, 2007 11:15 pm Subject: JMS input node on aix |
now We changed to use MQInput node, everything is going fine.
copy to elvis, cause this project will be validated by customer soon, I will try to get trace when validation was done. |
| Topic: JMS input node on aix |
tiangl
Replies: 6
Views: 4994
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Mar 14, 2007 8:21 pm Subject: JMS input node on aix |
| thanks jeff, i will think about your suggestion. btw, there's no errores in MB log. |
| Topic: JMS input node on aix |
tiangl
Replies: 6
Views: 4994
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Mar 14, 2007 7:50 pm Subject: JMS input node on aix |
| cause we has many other J2EE application will put msg into MB, it's more convenient for those application to put jms msg. |
| Topic: JMS input node on aix |
tiangl
Replies: 6
Views: 4994
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Mar 14, 2007 7:29 am Subject: JMS input node on aix |
hi,
we wrote a simple flow which use JMS input node and output node. this sample can be running very well on windows. now we deployed it on AIX, we did all thing which we'v done on windows,like exe ... |
