| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| MQ as a transaction coordinator for UDB |
« View previous topic :: View next topic » |
| Author |
Message
|
| TheAndroid |
 Posted: Tue Dec 04, 2007 12:26 pm Post subject: MQ as a transaction coordinator for UDB |
 |
|
Novice
Joined: 04 Dec 2007
Posts: 23
|
Hi all,
I am getting a message from UDB:
FATAL SQL ERROR
SQL0998N Error occurred during
transaction or heuristic processing.
Reason Code = "9". Subcode = "".
SQLSTATE=58005
SQLSTATE 58005: A system error (that
prevents the successful execution of
subsequent SQL statements) occurred.
I was wondering if anyone had seen this before. I am using MQ v6 as a
transaction coordinator for a 32bit COBOL program. When I was running
V5.3, this worked fine. Now, I'm getting these errors. I rebuilt the
switch files as directed and made sure it was in the correct
directory.
I know MQ is trying to use the 32 bit version as I can rename the
one in /var/mqm/exits and it will complain when I do MQBEGIN. However,
the documentation at boulder says it should be using the 64 bit one.
If I delete the 32 bit db2swit file, I get 2212 errors
(RESOURCE_MANAGER_NOT_FOUND) errors so it is demanding the 32
version.
I'm at a loss on this as when I do db2 ? sql0998 the response shows
two subcodes. Neither of which I'm getting. db2diag on the server
doesn't show anything either. Either way, the error message itself is NO help!
I realize this sounds more like a UDB post, but I have no idea what to look at next. The only thing which has changed is MQ, so I have to suspect it.
Help! |
|
| Back to top |
|
 |
| JuulV |
| Posted: Tue Dec 04, 2007 1:08 pm Post subject: |
|
|
Apprentice
Joined: 05 Sep 2007
Posts: 28
Location: Belgium
|
Just a wild guess... do you have both 32- and 64-bit versions of the switch files? And are these in the correct locations? With correct permissions? And are they correctly defined in the qm.ini file?
I've noticed that since WMQ 6.0, even though I only use 32-bit applications, I need to compile exits in both 32 and 64-bit mode, AND place them in the directories named in the ExitPath section of the qm.ini file. I never got around researching this any further, but I ran into problems trying to specify the path in the "Module=" entries...
_________________
Juul Vanparijs
Senior Developer
Cressida Technology Ltd |
|
| Back to top |
|
|
| TheAndroid |
| Posted: Tue Dec 04, 2007 1:43 pm Post subject: |
|
|
Novice
Joined: 04 Dec 2007
Posts: 23
|
Juul,
Yep, they are both there. I used the xaswit.mak file which came with MQ. I beleive the command line was:
make -f xaswit.mak db2swit
The files belong to user mqm with user and group execute rights.
I just read in one of the queue manager error logs that DB2 doesn't support xa functions from 64 bit applications using the 32 bit interface. If that's true, why does the make file build both?
Thanks! |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Tue Dec 04, 2007 1:47 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
The qmgr is 64bit.
It needs the 64bit version of the exit for itself.
It needs the 32bit version for any piece that is talking to it, that is 32bit.
This may include the XA interface calls to DB2, if your app is 32bit.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| TheAndroid |
| Posted: Wed Dec 12, 2007 7:04 am Post subject: |
|
|
Novice
Joined: 04 Dec 2007
Posts: 23
|
Jeff,
I'm a bit confused here then. Does this mean MQ v6 will coordinate transactions on UDB with 32 bit apps? All evidence is to the contrary. |
|
| 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
|
|
|
|
