| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| two Questions about MQ XA |
« View previous topic :: View next topic » |
| Author |
Message
|
| tiangl |
 Posted: Tue Apr 19, 2005 9:32 am Post subject: two Questions about MQ XA |
 |
|
Apprentice
Joined: 19 Nov 2004
Posts: 48
|
Q1. if i take MQ to be my XA coordinator, i define switch file path and db name,userid and password for Database in qm.ini . i'm just wondering what status of DB MQ will check during starting QM? what status of DB can make QM starting with error? if error said "DB have some uncommit transaction", what's mean of that?
Q2. during two-phase commit in MQ global work unit, what will happen if DB crashed? MQ app will get error quickly? if not, is there any way to make it quicken?
thanks! |
|
| Back to top |
|
 |
| kirani |
| Posted: Tue Apr 19, 2005 7:36 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
1. Can you provide more details on when/how do you get these errors? Have you tried looking at DB side to see which ones are uncommited transactions?
2. I think you will get error at the time of Transaction commit.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| tiangl |
| Posted: Wed Apr 20, 2005 2:19 am Post subject: |
|
|
Apprentice
Joined: 19 Nov 2004
Posts: 48
|
Kiran,
For Q1, after defined XA resource(Oracle) in QM.ini, i tried to start QM but got failed, there's some error in error-log of MQ,said "uncommit transaction in DB". after removing XA Resource definition,everything is ok. so, i just want to know what MQ will detect DB, what status of DB can make MQ starting failed?
For Q2, i had test, yes, will get error code once invoking mqcommit.
thanks! |
|
| Back to top |
|
|
| kirani |
| Posted: Thu Apr 21, 2005 10:02 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Have you tried using dspmqtrn and/or rsvmqtrn command. Your DBA might be able to guide you in seeing outstanding DB transactions.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| 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
|
|
|
|
