Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Sybase XA-transaction

158 views
Skip to first unread message

RayLee

unread,
Feb 18, 2009, 2:12:33 AM2/18/09
to
Hi,

When I configure JConnect in WebSphere 6.1 to use XA transaction, it
returned me the following error:

Error 500: java.sql.SQLException: JZ0XS: The server does not support
XA-style transactions. Please verify that the transaction feature is enabled
and licensed on this server.DSRA0010E: SQL State = JZ0XS, Error Code = 0

Do I need to check whether our Sybase 12.5.3 support XA transaction?

Any steps to do the checking?

Thanks for your advice in advance,
Raymond


J

unread,
Feb 18, 2009, 12:34:43 PM2/18/09
to
On 17 Feb 2009 23:12:33 -0800, "RayLee" <Ray...@pp.com> wrote:

On ASE 12.0 and up, you need the "DTM feature" in order to do XA
style transactions. You also need to enable and configure the
connection user who will do DTM/XA transactions. See the ASE
documentation set for details.

I have script which checks the ASE setup that I will include here. I
believe your dba should be able to understand the commands from it.

/*
** first check if the ASE_DTM feature is licensed
*/

if (license_enabled("ASE_DTM") = 1)
begin
print "GOOD: ASE_DTM licensed properly"
end
else
begin
print "BAD : check ASE_DTM licensing by looking at the server
log messag
es"
end
go

/*
** check to see if the DTM is configured via the
** sp_configure "enable DTM",1
** command
*/
declare c1 cursor for select value from master.dbo.sysconfigures where
name = "e
nable DTM"
go

open c1
go

declare @result int
fetch c1 into @result
if (@result = 1)
begin
print "GOOD: DTM is configured"
end
else
begin
print "BAD : DTM not configured, look at sp_configure ""enable
DTM"" and li
censing"
end
go

close c1
go

deallocate cursor c1
go

/*
** check to see if this user has
** been granted the dtm_tm_role
*/

if ( proc_role("dtm_tm_role") = 1)
begin
print "GOOD: This user has the dtm_tm_role"
end
else
begin
print "BAD : Must sp_role ""grant"", ""dtm_tm_role"",
""userid"" "
end
go

/*
** check to see if the "dtm detach timeout period" is set
** sp_configure "dtm detach timeout period",<minutes>

declare c2 cursor for select value from master.dbo.sysconfigures where
name = "dtm detach timeout period"
go

open c2
go

declare @result int
fetch c2 into @result
if (@result = 0)
begin
print "RECOMMEND: sp_configure ""dtm detach timeout period"",
<minutes>"
end
else
if (@result > 5)
begin
print "GOOD: ""dtm detach timeout period"" is set"
end
else
print "NOT too GOOD: ""dtm detach timeout period"" is set but the
value too
high"
go

close c2
go

deallocate cursor c2
go

Here is an example of it running :

Solaris/xaIvp-> isql -Uscott -Pscottpw -SjandersServer < chkdtm.sql
GOOD: ASE_DTM licensed properly
(1 row affected)
GOOD: DTM is configured
GOOD: This user has the dtm_tm_role
(1 row affected)
NOT too GOOD: "dtm detach timeout period" is set but the value too
high

RayLee

unread,
Feb 18, 2009, 10:45:59 PM2/18/09
to
Thanks for your reply.

"J" <jtotall...@sbcglobal.net> wrote in message
news:499c44b6...@forums.sybase.com...

Derek Asirvadem

unread,
Feb 23, 2009, 12:12:21 PM2/23/09
to
> On 2009-02-18 18:12:33 +1100, "RayLee" <Ray...@pp.com> said:
>
> Error 500: java.sql.SQLException: JZ0XS: The server does not support
> XA-style transactions. Please verify that the transaction feature is enabled
> and licensed on this server.DSRA0010E: SQL State = JZ0XS, Error Code = 0

Interesting error. Have you checked that JConnect can connect to ASE ?

I think the problem is IBM WebSphere, within its XA support, does not
support Sybase.

--
Cheers
Derek
Senior Sybase DBA / Information Architect
Copyright Š 2008 Software Gems Pty Ltd
--
Quality Standards = Zero Maintenance + Zero Surprises
Performance Standards = Predictability + Scaleability

J

unread,
Feb 24, 2009, 5:16:17 PM2/24/09
to
On 23 Feb 2009 09:12:21 -0800, Derek Asirvadem
<derek.a...@gmail.com> wrote:

I have done Sybase XA transactions with Websphere before. He getting a
very specific error from the jConnect driver about the ASE DTM setup.

Jay

0 new messages