| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Two-phase commit with mqseries 5.2 as the tm and Sybase 12.5 |
« View previous topic :: View next topic » |
| Author |
Message
|
| bgoldstein |
 Posted: Tue Apr 23, 2002 7:13 am Post subject: |
 |
|
Novice
Joined: 14 Feb 2002
Posts: 19
Location: Ameren Services, St.Louis,Mo., USA
|
1. Does anyone have this working?
2. Has anyone had the problem that I am describing?
3. I have a problem open with Sybase and IBM, but we have been unable to solve this problem!
Our sybase DBA setup the dtm facility on Sybase. When I start the qmgr, I get a message AMQ7605: The XA resource manager xaserver has returned an unexpected return code -5, when called for xa_open.
Here is the sybase log file:
(snip)
2002/04/23 07:29:34: 0x3d8e,N/A: [xa__dtm_1result/145] Misc trace: value: 3
2002/04/23 07:29:34: 0x3d8e,N/A: [xa__dtm_check/371] Error: No rows for returned for DTM configuration status
2002/04/23 07:29:34: 0x3d8e,N/A: [xa__dtm_check/372] ASE I/F trace: retstat: -3 ([XAER_RMERR])
2002/04/23 07:29:34: 0x3d8e,N/A: [_sybtux_xa_conn_free/919] Misc trace: Enter
2002/04/23 07:29:34: 0x3d8e,N/A: [_sybtux_xa_conn_free/924] Misc trace: return, retstat: 1 ([CS_SUCCEED])
2002/04/23 07:29:34: 0x3d8e,N/A: [xc_connect/426] Connection trace: retstat: -5 ([XAER_INVAL])
2002/04/23 07:29:34: 0x3d8e,N/A: [xc_open/78] Connection trace: retstat: -5 ([XAER_INVAL])
2002/04/23 07:29:34: 0x3d8e,N/A: [xal_freelrm/434] RM trace: Enter
2002/04/23 07:29:34: 0x3d8e,N/A: [xal_freelrm/539] RM trace: return, retstat: 1 ([CS_SUCCEED])
2002/04/23 07:29:34: 0x3d8e,N/A: [xa_open/193] Error: Return retstat: -5 ([XAER_INVAL])
rmid: 1, flags:[], info: -U******** -P******** -NMQ_CONNECT -L/var/mqm/xatmlogs/pomqxa.log -Tall
(snip)
Here is my qm.ini file:
XAResourceManager:
Name=xaserver
SwitchFile=/opt/mqm/xatm/bin/sybswit
XAOpenString=-U******** -P******** -NMQ_CONNECT
-L/var/mqm/xatmlogs/pomqxa.log
-Tall
Here is my Sybase DBA's xa_config file:
[xa]
lrm=MQ_CONNECT
server=SYBD1
xaserver=xaserver
_________________
+
| Barry Goldstein
| Ameren Services
| Saint Louis, Missouri
| bgoldstein@ameren.com
| (314) 554-4351
+ |
|
| Back to top |
|
 |
| VivekMeshram |
| Posted: Wed Apr 24, 2002 3:31 am Post subject: |
|
|
Voyager
Joined: 25 Mar 2002
Posts: 83
|
Hi Barry,
1. I would like to know the OS level and Version!! Since you are using MQ 5.2 and Sybase 12.5 its compartable for XA.
2. Are you starting the Queue Manager using the same user which you have in qm.ini or mqm user and the database user rights.
3. Do have the the system syslog.
4. Try to find out the error code -5 for the Sybase database.
I will look forward to hear you.!!
Regards
Vivek Meshram
EAI Consultant.
Singapore.
[ This Message was edited by: VivekMeshram on 2002-04-24 04:32 ]
[ This Message was edited by: VivekMeshram on 2002-04-24 04:33 ] |
|
| Back to top |
|
|
| bgoldstein |
| Posted: Wed Apr 24, 2002 12:13 pm Post subject: |
|
|
Novice
Joined: 14 Feb 2002
Posts: 19
Location: Ameren Services, St.Louis,Mo., USA
|
I am running Solaris 2.7. The results that I am getting are now a little different. I found a problem with the environment. When I run the program with the incorrect environment (environment variables pointing to sybase 11.9.2), I get the rc=5 [XAER_INVAL]. When I run the program with the correct environment (environment variables pointing to sybase 12.5), I get an rc=3 [XAER_RMERR].
Do you have this working?
Are you trying to get this working?
|
|
| Back to top |
|
|
| bgoldstein |
| Posted: Thu May 16, 2002 6:38 am Post subject: Additional information |
|
|
Novice
Joined: 14 Feb 2002
Posts: 19
Location: Ameren Services, St.Louis,Mo., USA
|
I have some additional information to post in this thread:
In the mqseries application, I am getting a RC 2122 [MQRC_PARTICIPANT_NOT_AVAILABLE] from the MQBEGIN call.
I now get a -3 [XAER_RMERR] RC from xa_open and the following cryptic message from Sybase.
2002/05/15 11:15:18: 0x64ff,N/A: [xaclientmsg_cb/847] Message: Nr=6, Sev=5, L=5, O=3; Msg: ct_connect(): network packet layer: internal net library error: Net-Lib protocol driver call to read data failed
I have searched all over for an indication of what this Sybase message means and just can't find it at all.
_________________
+
| Barry Goldstein
| Ameren Services
| Saint Louis, Missouri
| bgoldstein@ameren.com
| (314) 554-4351
+ |
|
| Back to top |
|
|
| gvpatil |
| Posted: Mon May 20, 2002 7:24 am Post subject: Check libpath for the user.. |
|
|
Newbie
Joined: 18 Jan 2002
Posts: 9
|
Check the LIBPATH for the user id running the application. Make sure that you can access just alone Sybase with no problems, you will hopefully find some answer there...
gvpatil |
|
| Back to top |
|
|
| bgoldstein |
| Posted: Tue Jun 18, 2002 11:18 am Post subject: We finally got this working |
|
|
Novice
Joined: 14 Feb 2002
Posts: 19
Location: Ameren Services, St.Louis,Mo., USA
|
We finally solved this problem, it had to do with somebody not playing nice (being thread safe). We linked the switch load module with the reentrant versions of the Sybase libs (lib*_r.so) and we were able to get this working. According to the truss output the return code for a socket recv call was returning a -3 return code instead of a -11 (which indicated no message on a non-blocking call). This -3 return code was causing Sybase to give up on reading a message, instead of retrying the call.
The following line shows excerpts from the make file for my switch load module:
...
SYBVER=-DSYBASE_V12 -D_REENTRANT
SYBLIBS=-lintl_r -lxadtm -lct_r -lcs_r -lcomn_r -ltcl_r -lnsl -ldl -lthread
...
$(CC) -G -V -e MQStart $(SYBVER) $(SYBLIBPATH) $(SYBLIBS) -o $@ sybswit.c
...
_________________
+
| Barry Goldstein
| Ameren Services
| Saint Louis, Missouri
| bgoldstein@ameren.com
| (314) 554-4351
+ |
|
| Back to top |
|
|
| kamy |
| Posted: Fri Jan 24, 2003 11:11 am Post subject: Sybase + MQSeries 5.2 + XA |
|
|
Novice
Joined: 26 Oct 2001
Posts: 21
|
Hi,
Question
Hasanybody used MQSeries Java classes to write an MQ put adapter with a sybase database as a participant in an XA transaction?
thx
- Kamy |
|
| 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
|
|
|
|
